postion of dropdown list with sheet combobox

S

sunilpatel

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
 
O

OssieMac

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox filtering 2
Word VBA - Automatic change content of a cell in table using dropdown list 5
ComboBox Dropdown not under control 1
populate dropdown/combobox on userform with specific values from s 3
Set value of a cell with a dropdown list during run time (C#) 10
combobox problem 0
.dropdown problem 1
Combo box 0

Top