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

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