+ Reply to Thread
Results 1 to 2 of 2

Autofill userform listboxes using a loop

  1. #1
    Registered User
    Join Date
    10-06-2011
    Location
    Salt Lake City, UT
    MS-Off Ver
    Excel 2010
    Posts
    78

    Autofill userform listboxes using a loop

    I have a userform with 40 listboxes. I use the following code to fill one listbox using a list of values in an excel sheet:

    Please Login or Register  to view this content.
    I want to add another loop to this to fill all the listboxes and say something like this:

    Please Login or Register  to view this content.
    Any ideas how to make this work?

    Thanks in advance

  2. #2
    Forum Contributor
    Join Date
    12-31-2012
    Location
    Jhang, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    250

    Re: Autofill userform listboxes using a loop

    First of all you need to name the list-boxes as Listbox1, Listbox2.... Listbox40

    then change your code like this:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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