+ Reply to Thread
Results 1 to 4 of 4

Populate UserForm List with values from an Array

  1. 06-21-2019, 08:25 PM #1
    plans
    plans is offline
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Populate UserForm List with values from an Array

    Hello,
    I have a list of items, called uArray(i)

    My next code line is calling for a userform:

    Please Login or Register  to view this content.
    The MyList userform has a ListBox.

    My question is, how to get the UArray(i) list into the userform's ListBox.
    Thanks
    Reply With QuoteRegister To Reply
  2. 06-21-2019, 09:36 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Populate UserForm List with values from an Array

    Hello plans,

    Assign the array to the List property of the ListBox. For example, if the ListBox name is ListBox1 Then ListBox1.List = uArray()
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 06-22-2019, 09:34 AM #3
    plans
    plans is offline
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Re: Populate UserForm List with values from an Array

    Leith,
    Thanks for the response;
    I am getting a "Run-time error '9':
    Subscript out of range
    message.
    Could you please advise?
    Thanks
    Reply With QuoteRegister To Reply
  4. 06-22-2019, 10:15 AM #4
    plans
    plans is offline
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Re: Populate UserForm List with values from an Array

    OK, I used 
    Please Login or Register  to view this content.
    which solved it.
    Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Bring up userform when doubleclicking on activated cell, then populate array from inputs
    By Njineer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2018, 12:08 PM
  2. [SOLVED] Pull all values from UserForm List Box and Paste them to Dynamic Array in Worksheet
    By TFiske in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2018, 01:08 PM
  3. Values from Array, populate into Cell
    By Siegfrid15 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-26-2017, 04:52 AM
  4. [SOLVED] Populate userform combo box with named dynamic list
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-28-2014, 05:17 PM
  5. Do I need a table array formula to populate names from a list?
    By MajorT in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-19-2013, 11:03 AM
  6. Populate multi-column list in sheet not in UserForm
    By afzal001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2008, 12:26 PM
  7. [SOLVED] Populate list box with multi-dimensional array
    By Graham Whitehead in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2006, 07:30 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1