Combobox & Display
 

On Userform in Excel VBA, I put a combobox of smallest size required t
save space on the form. When the form is loaded & combobox arro
clicked, the white display window, showing list of items, is much wide
than the combobox width.
I checked in the property of the combobox to change the size of th
display but cannot find. This is more uncomfortable when the combobo
is at the side edge of form, part of the list display is outside th
userform. Is there a way to adjust

--
Bhuktar
-----------------------------------------------------------------------
Bhuktar S's Profile: http://www.excelforum.com/member.php...nfo&userid=234
View this thread: http://www.excelforum.com/showthread.php?threadid=26537

Combobox & Display
 

I think you may need to set the autosize property to false.

Steve
"Bhuktar S" wrote in message
...

On Userform in Excel VBA, I put a combobox of smallest size required to
save space on the form. When the form is loaded & combobox arrow
clicked, the white display window, showing list of items, is much wider
than the combobox width.
I checked in the property of the combobox to change the size of the
display but cannot find. This is more uncomfortable when the combobox
is at the side edge of form, part of the list display is outside the
userform. Is there a way to adjust?


--
Bhuktar S
------------------------------------------------------------------------
Bhuktar S's Profile:
http://www.excelforum.com/member.php...fo&userid=2343
View this thread: http://www.excelforum.com/showthread...hreadid=265375