Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
postion of dropdown list with sheet combobox
I have a sheet combobox, when populated with 10-15 items all dropdown list
is fully visible and is underneath the combobox. But when more item are included the dropdown list moves to the right. This obstructs data on the sheet. Is there a way to "fix" dropdown position so it is always underneath combobox. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
postion of dropdown list with sheet combobox
I haven't seen this problem before so am wondering if it is being caused by
something in you code. However, try setting the Listwidth property to the same as the Width. Listwidth defaults to zero and I think that makes it variable. Don't know if it will help but worth a try. -- Regards, OssieMac "sunilpatel" wrote: I have a sheet combobox, when populated with 10-15 items all dropdown list is fully visible and is underneath the combobox. But when more item are included the dropdown list moves to the right. This obstructs data on the sheet. Is there a way to "fix" dropdown position so it is always underneath combobox. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combobox dropdown list??????????? | Excel Discussion (Misc queries) | |||
ComboBox dropdown list? | Excel Discussion (Misc queries) | |||
Show worksheet ComboBox DropDown list even when your not in it | Excel Programming | |||
Combobox List to list Numerical Values ONLY in Column A is specific Sheet.... | Excel Programming | |||
adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) |