Thread: list boxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default list boxes

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