Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 86
Default Can you change the font and font size for a forms control ?

On 10/28/2010 2:48 PM, exceluser wrote:
...When you make a selection in the drop down list, the font
appearance is correct.
But selecting another cell causes the selection in the drop down
list to switch to what looks like a very jaggy MS Sans Serif Bold
font.
In Excel 2007, inserting an ActiveX Combo Box on a blank worksheet
nets the same result.


Without seeing it it's hard to tell, how about setting the combobox font
properties in the Enter event? Will that correct it?

Private Sub ComboBox1_Enter()
'set font properties here
End Sub

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you change the font and font size for a forms control ? exceluser Excel Programming 1 October 26th 10 07:25 AM
Change font and/or font size in headers, footers and body via VBA BEEJAY Excel Programming 1 December 7th 09 07:36 PM
change font in a forms control combo box JRTB Excel Discussion (Misc queries) 3 February 25th 09 09:34 PM
change font size for control labels MJP Excel Worksheet Functions 1 May 23rd 07 05:06 AM
how do I change the font size in a combo box from the forms toolba ldurst Excel Discussion (Misc queries) 1 June 30th 06 03:08 AM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"