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

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)

wrote in message
oups.com...
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

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

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)

wrote in message
oups.com...
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

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