Making combobox listing containing values larger

[Todd Huttenstine]

I have multiple comboboxes on a userform. When you click
on the dropdown button on the combobox, it shows you all
the values that it contains. Heres my problem... Some of
the values in the combobox are larger than the length of
the combobox, so therefore when I click on the drop down
arrow, I cannot see the entire length of the longer
items. The entire value gets cut off for viewing. It is
going to be very difficult for me to increase the length
of the combobox, so is there anyway I can get the entire
length to stick out for viewing and then if I select it,
it can go in the combobox?

Thank you


Todd Huttenstine

 

[Guest]

Hi Todd,

Don't sweat. The simplest and effective way is, as you realise, to length/widen the combobox. Why is it "going to be very difficult" to do so? If it's in a userform, just widen the whole userform to accomodate it. If it's in a worksheet, just widen the column.

SuperJas.

 

[Todd Huttenstine]

Thanx for the response. The reason I cant widen the
combobox is because the userform is already as wide it
gets (and if I could get it wider, it would run off my
screen and I would have to scroll. I dont want this. I
have been on some websites and I believe some programs
where I have seen some values in the combobox being wider
than the combobox itself. In this case, when I select one
of those values, the white background around the value I
select suddenly gets as long as it needs to be. Then when
I select it, it is put into the combobox and in order to
see the entire value, I must use my cursor or arrow key
and scroll to the end.


Thank you


Todd Huttenstine

-----Original Message-----
Hi Todd,

Don't sweat. The simplest and effective way is, as you

realise, to length/widen the combobox. Why is it "going to
be very difficult" to do so? If it's in a userform, just
widen the whole userform to accomodate it. If it's in a
worksheet, just widen the column.