list boxes

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)

<RobcPettit@yahoo.co.uk> wrote in message
news:1140259884.868870.315410@o13g2000cwo.googlegroups.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)

<RobcPettit@yahoo.co.uk> wrote in message
news:1140268262.830607.294140@g43g2000cwa.googlegroups.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