?
Solved

Banish the ScrollBar !

Posted on 2014-03-24
5
Medium Priority
?
191 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 36

Assisted Solution

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

   listBox1.HorizontalScrollbar = False 

Open in new window


?
0
 
LVL 48

Accepted Solution

by:
Martin Liss earned 1000 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 200 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 48

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

771 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