Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

Banish the ScrollBar !

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
Rayne
Asked:
Rayne
3 Solutions
 
KimputerCommented:
Did you ever try:

   listBox1.HorizontalScrollbar = False 

Open in new window


?
0
 
Martin LissRetired ProgrammerCommented:
The Listbox has a Scrollbars property that you can set in the IDE.
0
 
englanddgCommented:
Yep to both of those answers above.
0
 
RayneAuthor Commented:
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
 
Martin LissRetired ProgrammerCommented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now