Solved

Banish the ScrollBar !

Posted on 2014-03-24
5
180 Views
Last Modified: 2014-03-24
Hello Gurus,

Listbox is very good and I love it. But there is one problem with its appearance – when I put a list box on a excel user form – it shows annoying scroll bar – can I do anything to just get rid of that scroll bar and not show it?

Thank you
issueListBox.png
0
Comment
Question by:Rayne
5 Comments
 
LVL 35

Assisted Solution

by:Kimputer
Kimputer earned 200 total points
ID: 39951892
Did you ever try:

   listBox1.HorizontalScrollbar = False 

Open in new window


?
0
 
LVL 46

Accepted Solution

by:
Martin Liss earned 250 total points
ID: 39951906
The Listbox has a Scrollbars property that you can set in the IDE.
0
 
LVL 3

Assisted Solution

by:englanddg
englanddg earned 50 total points
ID: 39951962
Yep to both of those answers above.
0
 

Author Comment

by:Rayne
ID: 39952018
Finally the annoying scroll bar gets banished from the pure vicinity of my beautiful userfrom1.

thank you all, cant thank you enough for your kindness
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 39952026
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2013
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
My experience with Windows 10 over a one year period and suggestions for smooth operation
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now