On Feb 25, 2:23*pm, "Rick Rothstein \(MVP - VB\)"
wrote:
By the way, there is a ListWidth property you can set to make the drop-down
portion of the control wider than the edit field (plus drop down arrow)
section... is that what you were trying to accomplish?

Rick

"Rick Rothstein (MVP - VB)" wrote in
l...



What did you mean when you said "I have tried to increase the box width"?
How (by what means) did you increase it?

Rick

"Madiya" wrote in message
...
Hi all,
I have completed a project with the help of this NG which is running
fine but having a small problem.
I have a combobox on a userform.
This box shows texts strings collected *from the sheets.
This text is not shown in full. I have tried to increase the box width
but then texts are shown in part only. rest of the width of box
dropdown is blank. Even I can see the half cherecter indicating there
is text but is not shown full.

There must be a setting for this and I am surly overlooking the same.

Pl help.

Regards,
Madiya- Hide quoted text -

- Show quoted text -

Rick,
Thanks for reply.
I opened vba editor and dragged the comboboc border to increase its
width.
Now I tried listwidth also.
It increase the width of the dropdown but is not fully filled up with
the data.

for e.g. if text tring is "this is great NG to lot of things" then
combobox width is
====================
box drop down width is (increased with listwidth as suggested by you)
=================================

text appearing width is
============
text appeared is
this is great NG t

rest of the text is cut and is not appearing.

Any thoughts?
Hope I am explaining properly.
Regards,
Madiya