list boxes

[RobcPettit]

Hi, Im using a userform with list boxes. In vna Im using
ListBox1.AddItem to add text. When I ad text the list boxes show scroll
bars, is there a way to stop these as I dont need them and they make
the form look untidy.
Regards Robert

 

[Bob Phillips]

The scrollbars are there as there are too many items to display. Either
reduce them, or make the listbox bigger.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[RobcPettit]

thanks for the reply, Ive tried widening them, (scroll bars width ways
only), but I have to go about 5 times wider than the data.
Regards Robert

 

[Bob Phillips]

That sounds as though your source data has trailing spaces. Have you tried
trimming it?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[RobcPettit]

I think you could be correct, Im entering numbers, which i have to
roung to 2 decimal places first. Ive tried trim function but this has
no effect.
Regards Robert