combobox/drop down list extra left margin

[liderplaza]

in a userform when you add a combobox/drop down menu, then adding some items in it,
opening the list, there is extra space at the left of the each menu item,
how can I disable these extra spaces?

The combobox/drop down left margin in the box itself can be disabled via setting selectmargin to false.
but how can I disable these spaces within the list? the url below show this extra space.

http://i.stack.imgur.com/z0qPd.jpg

[Norie]

Those spaces aren't in the list.

[liderplaza]

what do you mean? I haven't added those spaces to the list,
they are showing by default,

a simple code like
myuserform.mycombo.additem "first" and etc.
put these spaceless items to the combo, but when showing they have that margin you see in the pic.

[Norie]

Neither has VBA/Excel added any spaces.

[liderplaza]

ofcourse, you are right, i was talking about removing those margins from left side. I want it to be visually perfect,
the added items are fine, just i don't like them to be shown with margin. thats all. any idea?

regards.

[Norie]

Not that I can think of.

Setting SelectionMargin doesn't seem to do much and I can't see any other properties that might help.

I've tried playing about with a few things but just ended up with a really ugly combobox.

[liderplaza]

yeah, me too, thanks anyway, guess it is what it is...

[thilag80]

Hi, anyone got answer for this, please

[protonLeah]

thilag80
Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.