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

Top