Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Listbox control Userform (2002 xp)

    Hi all,

    Can some one tell me is there a way to expand a listbox pick, normally, it's one line of for each item in the listbox, but is there a way to have an item that is more than one entry, the item could be multiple?

    Thanks, Darryl

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Listbox control Userform (2002 xp)

    Do you mean something along the lines of the following:
    Birds
    Fish
    Insects
    Mammals
    Bipeds
    Quadrupeds
    Weapons
    Regards
    Don

  3. #3
    Lounger
    Join Date
    Sep 2008
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listbox control Userform (2002 xp)

    Perhaps something like
    <pre>Private Sub ListBox1_Click()
    With Me.ListBox1
    If .ListIndex = 1 Then .ListIndex = 3
    End With
    End Sub</pre>


  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Listbox control Userform (2002 xp)

    I don't see the point of that code.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Listbox control Userform (2002 xp)

    Do you mean a treeview, such as the left hand pane of Windows Explorer?

  6. #6
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Listbox control Userform (2002 xp)

    Hey guys,

    Thanks for your replies,

    I think what I mean is if you are using a listbox to illustrate Text say 50 characters, and you only have room for 10 characters per list item is there another way of parsing the string and or adding it as an item ? Should I just use a textbox control with the multiline property?

    Thanks,
    Darryl.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Listbox control Userform (2002 xp)

    You can increase the column width; this enables the user to see the entire entry by using the horizontal scroll bar. (Of course, if there is enough room. you should increase the width of the list box.)

Posting Permissions

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