+ Reply to Thread
Results 1 to 6 of 6

editing ScrollBars in ListBoxes?

  1. #1
    Registered User
    Join Date
    03-31-2009
    Location
    Auburn Alabama
    MS-Off Ver
    Microsoft Office Excel 2007 (Windows)
    Posts
    99

    editing ScrollBars in ListBoxes?

    Hello,

    My question is about ScrollBars in ListBoxes.

    I've created my first ListBox and I'm having difficulty with the ScrollBars. I don't know how to change settings on either the vertical or the horizontal ScrollBar.

    As of now, my ListBox has a horizontal ScrollBar and a vertical ScrollBar. I want to remove the horizontal ScrollBar altogether. I want the user to be able to only scroll up or down through the values in the ListBox.

    Also, the size of the Vetical ScrollBar is tiny. Is their a way to control it's actual size?

    Thanks for the help!
    Last edited by CrazyFileMaker; 05-30-2009 at 03:17 AM.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: editing ScrollBars in ListBoxes?

    CrazyFileMaker
    If you add a Large value than the text width in the Listbox properties > Columnwidths
    it will do both increase and remove the scroll bars
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    03-31-2009
    Location
    Auburn Alabama
    MS-Off Ver
    Microsoft Office Excel 2007 (Windows)
    Posts
    99

    Re: editing ScrollBars in ListBoxes?

    Pike,
    Thanks for the response.

    And the response to my other question as well!

    I appreciate your help a great deal. Cheers!

  4. #4
    Registered User
    Join Date
    03-31-2009
    Location
    Auburn Alabama
    MS-Off Ver
    Microsoft Office Excel 2007 (Windows)
    Posts
    99

    Re: editing ScrollBars in ListBoxes?

    Oh, and do you know if there is any way i can make the ListBoxes all one uniform size independent of their value without scrollbar?

    The reason I ask is that I have 5 ListBoxes beside one another and they are all meant to hold Long Type numbers that can range from 1 to 1,000,000. Is there a way to have the 1 appear in a box the same size as the 1,000,000 and simply center itself, so as not to have the scroll bars?

    I can't figure out how big the ListBox needs to be in order to accomplish two uniformly sized boxes with contents of disproportionate sizes.

    Thanks!!!!

  5. #5
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: editing ScrollBars in ListBoxes?

    CrazyFileMaker
    You may be better off using combboxes
    The comboboxes have drop downs that you can resize with out changing the comboxbx viewing size

  6. #6
    Registered User
    Join Date
    03-31-2009
    Location
    Auburn Alabama
    MS-Off Ver
    Microsoft Office Excel 2007 (Windows)
    Posts
    99

    Re: editing ScrollBars in ListBoxes?

    Pike,

    Good suggestion. Worked perfectly. Thanks!
    Last edited by CrazyFileMaker; 05-30-2009 at 08:31 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1