Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you change the font and font size for a forms control ?
Is it possible to change the font and font size for a forms control
drop down list (not an ActiveX control) ? Exceluser |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you change the font and font size for a forms control ?
On 10/25/2010 6:22 PM, exceluser wrote:
Is it possible to change the font and font size for a forms control drop down list (not an ActiveX control) ? Exceluser Do you mean that you added a Combobox to a Userform, and you want to change the font family and font size of the text in the Combobox? If so right click on the Combobox, select Properties in the context menu, then in the Properties window click on the three dots at the right side of the right column where Font is displayed in the left column. Is this what you're looking for? http://en.allexperts.com/q/Excel-105...pdown-List.htm Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you change the font and font size for a forms control ?
Mike,
Thanks for responding. In Excel 2007, I added a Forms Control Combo Box. When selected, the Combo Box is specified as Drop Down 2. However, the font is too small. I would use the ActiveX Combo Box, but when a selection is chosen from the drop down list and another cell is selected, the selected value in the drop down list appears bolded. The font properties only seem to apply when the drop down list is dropped down. If the ActiveX Combo Box were to be used, is there a way to prevent the selection from displaying in bold. Exceluser |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you change the font and font size for a forms control ?
Mike,
I would post the worksheet, but the spreadsheet is over 10 MB and has too many external dependencies - you'd basically see a lot of cells with error results. 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. Exceluser |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you change the font and font size for a forms control ? | Excel Programming | |||
Change font and/or font size in headers, footers and body via VBA | Excel Programming | |||
change font in a forms control combo box | Excel Discussion (Misc queries) | |||
change font size for control labels | Excel Worksheet Functions | |||
how do I change the font size in a combo box from the forms toolba | Excel Discussion (Misc queries) |