Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Drop Down Button
Hi all, I have two Combo Box on my sheet. One is Combo Box (Form
Control) and other is Combo Box (ActiveX Control). My question is that when I change hight or width of Combo Box (Form Control) then the size of Drop Down arrow Button also changes but remains in squar shape. But when i change hight or width of Combo Box (ActiveX control) then the size of Drop Down arrow Button doesn't remains in squar shape. it get sques with adjustment of hight or width. How can i keep it in squar shape like if i make it bigger than the drop down arrow button should also become bigger but in proper squar shape like Combo Box (Form Control). I have to keep both Combo Box in my sheets due to the requirement but. I hope i was able to explain my question. Please can any friend can help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Drop Down Button
K;163444 Wrote: Hi all, I have two Combo Box on my sheet. One is Combo Box (Form Control) and other is Combo Box (ActiveX Control). My question is that when I change hight or width of Combo Box (Form Control) then the size of Drop Down arrow Button also changes but remains in squar shape. But when i change hight or width of Combo Box (ActiveX control) then the size of Drop Down arrow Button doesn't remains in squar shape. it get sques with adjustment of hight or width. How can i keep it in squar shape like if i make it bigger than the drop down arrow button should also become bigger but in proper squar shape like Combo Box (Form Control). I have to keep both Combo Box in my sheets due to the requirement but. I hope i was able to explain my question. Please can any friend can help. Hello K, How an object is drawn and sized is a function of the object class. Neither ComboBox exposes any properties through VBA to control the size of the drop down button. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45420 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box/Drop down box | Excel Discussion (Misc queries) | |||
Combo drop-down edit box | Excel Programming | |||
Combo drop down list | Excel Programming | |||
Drop Down List Box, Combo Box | Excel Discussion (Misc queries) | |||
setting up drop down combo box with VBA | Excel Programming |