LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default How to get rid of the bottom scroll bar in a ListBox

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Restore bottom scroll bar (Excel 2007) Redjagmike Excel Discussion (Misc queries) 4 May 23rd 07 05:56 PM
How do I use an Intellimouse to scroll listbox enteries in ExceL? Dean Excel Discussion (Misc queries) 0 June 29th 05 04:36 AM
How do I get bottom scroll bar back in Excel? Didea Setting up and Configuration of Excel 1 May 4th 05 02:33 PM
listbox doesn't scroll properly Deer Hunter Excel Programming 0 August 4th 03 02:11 PM


All times are GMT +1. The time now is 05:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"