Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't think you can remove it, but if you set the column width property to
a value greater than your data item width the scroll bar should be off. Cheers Nigel "Valeria" wrote in message ... Dear Experts, I would like to insert a ListBox in my userform that contains several items, and that can be scrolled down with a scroll-down bar on the right-hand side of the ListBox. The ListBox shows though with 2 scroll bars, one at the bottom and one on the right - how can I get rid of the one at the bottom? My code for populating the ListBox is: Sub Show_Userform() 'Fill the listbox1 With UserForm1.ListBox1 .RowSource = "" .AddItem "01" .AddItem "02" .AddItem "21" .AddItem "30" .AddItem "31" .AddItem "38" .AddItem "50" .AddItem "72" End With UserForm1.Show 0 End Sub Many thanks in advance. Best regards, Valeria ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Restore bottom scroll bar (Excel 2007) | Excel Discussion (Misc queries) | |||
How do I use an Intellimouse to scroll listbox enteries in ExceL? | Excel Discussion (Misc queries) | |||
How do I get bottom scroll bar back in Excel? | Setting up and Configuration of Excel | |||
listbox doesn't scroll properly | Excel Programming |