+ Reply to Thread
Results 1 to 7 of 7

Listbox Update on user form

  1. #1
    Registered User
    Join Date
    01-16-2009
    Location
    Detroit MI
    MS-Off Ver
    Excel 2003
    Posts
    24

    Listbox Update on user form

    HAPPY FRIDAY WEEKEND WARRIORS!!!

    So, I have searched high and low but I can't find any good examples of a listbox in a user form..... Any code , link or examples would be greatly appreciated!!!!

    Here is what I'm trying to do:

    On load of userform:
    - vba scans sheet and determines what rows are not hidden
    - vba updates listbox to show non hidden rows with multiple columns



    Thanks,
    Griff

  2. #2
    Registered User
    Join Date
    01-16-2009
    Location
    Detroit MI
    MS-Off Ver
    Excel 2003
    Posts
    24

    re: Listbox Update on user form

    double post........
    Last edited by Irish_Griffin; 10-02-2009 at 03:45 PM.

  3. #3
    Registered User
    Join Date
    01-16-2009
    Location
    Detroit MI
    MS-Off Ver
    Excel 2003
    Posts
    24

    re: Listbox Update on user form

    Please, Someone explain how I can assign values into a list box.

    this isn't working
    Please Login or Register  to view this content.
    Last edited by Irish_Griffin; 10-02-2009 at 03:50 PM.

  4. #4
    Registered User
    Join Date
    01-16-2009
    Location
    Detroit MI
    MS-Off Ver
    Excel 2003
    Posts
    24

    re: Listbox Update on user form

    Running out of coffeeeeee..... Friday night, want to go party.... not ... much...time..... must resist sneeking out of office =-P

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

    Re: Listbox Update on user form

    Youv'e not actually said what you want, are you sking for code to load the ListBox or update it as your Thread Title implies?

    Attach a sample workbook so that we can see what your data layout is
    Hope that helps.

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

    Free DataBaseForm example

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,656

    Post Re: Listbox Update on user form

    Your second command simply overwrites the first columns contents.
    Assuming your listbox has the columncount set to 2 or more
    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  7. #7
    Registered User
    Join Date
    01-16-2009
    Location
    Detroit MI
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Listbox Update on user form

    For search purposes:

    This site has a great easy to understand multi column listbox example.

    PEACE
    Griff

+ 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