Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub SetFont()
Dim cbox As MSForms.ComboBox Set cbox = ActiveSheet.OLEObjects("Combobox1").Object cbox.Font.Name = "Ariel" cbox.Font.Size = 9 End Sub -- Regards, Tom Ogilvy "Stefan" wrote in message ... I create a combobox on a new sheet and I want the font to be "Arial" size=9 in the listbox. I can not figure out how to write that code. Everything else works such as ListFillRange and LinkedCell. Can somebody help? Stefan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Viewing combobox properties | Excel Discussion (Misc queries) | |||
Setting Tab Properties in Excel | Excel Discussion (Misc queries) | |||
TextColumn Properties of ComboBox | Excel Discussion (Misc queries) | |||
setting properties for shapes | Excel Programming | |||
ComboBox ProperTies | Excel Programming |