View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1333_] Rick Rothstein \(MVP - VB\)[_1333_] is offline
external usenet poster
 
Posts: 1
Default Combobox width not showing full data

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.


The ComboBox is made up of two parts (not counting the drop down arrow)... a
TextBox that you can type into (what I think you are calling the ComboBox
width and which is sometimes called an Edit Field) and a ListBox that drops
down when you click the drop down arrow on the right side of the TextBox.

Now, are you saying that in the ListBox part, that the text is truncated as
shown above (with a lot of white space after it)? If so, that is a new one
on me... I've not seen that before. The only way I can duplicate what I
think you are describing is to set the ColumnCount to a value greater than 1
and also set the ColumnWidth to a value less than the number of points
necessary to display a complete line of text. Do you by any chance have
these two properties set like this?

Rick