+ Reply to Thread
Results 1 to 5 of 5

Listbox no scrollbars

  1. #1
    Forum Contributor
    Join Date
    02-07-2011
    Location
    netherlands
    MS-Off Ver
    Excel 2003
    Posts
    128

    Listbox no scrollbars

    I have found out how i create my userform and i got a few listboxes in it.


    There are multiple listboxes standing to each other. like it are columns of each other.
    When the value in the listbox reaches the right side of the listbox a scroll bar will apperear at the bottom. the same is when it reaches the bottom side of the listbox.

    is there anyway or property that these scroll bars will not be displayed?
    i want to create 1 custom scrollbar that works for every listbox so i need the scrollbars in the listbox to be hidden.
    Last edited by vin1; 03-21-2011 at 06:14 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Listbox no scrollbars

    ScrollBars are automatic with ListBoxes, why not use ComboBoxes?

    In fact why multiple ListBoxes, why not a multicolumn ListBox?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    02-07-2011
    Location
    netherlands
    MS-Off Ver
    Excel 2003
    Posts
    128

    Re: Listbox no scrollbars

    Ah didnt knew that you could do that with a listbox.

    I found it up and added it but..
    now igot some display issues.

    i want to resize 1 of the columns. like you do it with columns in your sheet of excel.
    is this possible per code or properties?

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Listbox no scrollbars

    Adjust the ColumnWidth Property

  5. #5
    Forum Contributor
    Join Date
    02-07-2011
    Location
    netherlands
    MS-Off Ver
    Excel 2003
    Posts
    128

    Re: Listbox no scrollbars

    i have solved it a diffrent way.

    i collected the strings into a variable and made 1 string of it. then added it.

+ 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