+ Reply to Thread
Results 1 to 3 of 3

getting a horizontal scroll bar in listbox

  1. #1
    Registered User
    Join Date
    09-29-2003
    Posts
    22

    getting a horizontal scroll bar in listbox

    Can anyone help me to get a horizontal scroll bar into a listbox ?

    My litbox is 180 point wide (set by width command) but my text is wider.

    I seem to remember if you set a small width in the .columnwidths property you can generate a scroll bar - but this is ignored for a single column listbox, which is what I have.

    If I reset the .Width property to something very small (eg 50) then I get the scroll bar but for some reason it doesn't scroll the fullwidth of the text.

    Any help greatly appreciated.

  2. #2
    Tom Ogilvy
    Guest

    Re: getting a horizontal scroll bar in listbox

    the width of the column (columnwidth property) should exceed the width of
    the listbox. The columnwidth should accomodate the length of your text.

    --
    Regards,
    Tom Ogilvy

    "jmoffat" <jmoffat.2438ty_1141380001.8191@excelforum-nospam.com> wrote in
    message news:jmoffat.2438ty_1141380001.8191@excelforum-nospam.com...
    >
    > Can anyone help me to get a horizontal scroll bar into a listbox ?
    >
    > My litbox is 180 point wide (set by width command) but my text is
    > wider.
    >
    > I seem to remember if you set a small width in the .columnwidths
    > property you can generate a scroll bar - but this is ignored for a
    > single column listbox, which is what I have.
    >
    > If I reset the .Width property to something very small (eg 50) then I
    > get the scroll bar but for some reason it doesn't scroll the fullwidth
    > of the text.
    >
    > Any help greatly appreciated.
    >
    >
    > --
    > jmoffat
    > ------------------------------------------------------------------------
    > jmoffat's Profile:

    http://www.excelforum.com/member.php...fo&userid=1151
    > View this thread: http://www.excelforum.com/showthread...hreadid=518624
    >




  3. #3
    Registered User
    Join Date
    08-07-2013
    Location
    Greece
    MS-Off Ver
    Excel 2007,2010
    Posts
    1

    Re: getting a horizontal scroll bar in listbox

    Take a look here it is a very clever solution indeed

+ 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