Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's a strange one: I can change the width of my custom combo box control
(on a toolbar) with the following. CommandBars("My Toolbar").Controls("My Combobox").Width = 200 It looks great...that is until I click on the down arrow when I find the actual list is still the old narrow width, tucked up at the left hand side of the combo box. I'm in Excel 2002/XP - has anyone any ideas? Thanks. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've found it - it's DropDownWidth. For some reason it doesn't appear in the
list of properties when you hit the full stop (but it's in Help) "Smallweed" wrote: Here's a strange one: I can change the width of my custom combo box control (on a toolbar) with the following. CommandBars("My Toolbar").Controls("My Combobox").Width = 200 It looks great...that is until I click on the down arrow when I find the actual list is still the old narrow width, tucked up at the left hand side of the combo box. I'm in Excel 2002/XP - has anyone any ideas? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Syntax for control source in combo box control | Excel Discussion (Misc queries) | |||
Form Toolbar verses Control Toolbar | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) |