+ Reply to Thread
Results 1 to 4 of 4

Populate Userform ComboBox from Dynamic Range

  1. #1
    Forum Contributor
    Join Date
    03-30-2016
    Location
    Gillette, WY
    MS-Off Ver
    Office 365
    Posts
    230

    Populate Userform ComboBox from Dynamic Range

    Hi all,

    I have a Userform in which I need to populate a dropdown ComboBox from a dynamic range in a sheet. I have a dynamic named ranged called:

    Lst_Locations
    Please Login or Register  to view this content.
    Then, I'm using the following code to populate a ComboBox in a multi-page Userform on the Edit Locations page:

    Please Login or Register  to view this content.
    However, the Combobox will not populate. What am I missing? I've used this code before to populate list boxes. I've tried several methods to get this to work but I'm lost...again. Thanks for the help. I've attached my project below.
    Attached Files Attached Files

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Populate Userform ComboBox from Dynamic Range

    Hi TFiske

    That sub is never running.... Initialise should read Initialize

    Because it has an S, instead of a Z, it is not recognised and does not automatically run when the form is loaded.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Contributor
    Join Date
    03-30-2016
    Location
    Gillette, WY
    MS-Off Ver
    Office 365
    Posts
    230

    Re: Populate Userform ComboBox from Dynamic Range

    facepalm. thanks.

  4. #4
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,176

    Re: Populate Userform ComboBox from Dynamic Range

    no need to cycle thru the records,
    just assign the range:

    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)

Similar Threads

  1. [SOLVED] populate userform combobox with only values from a range
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-03-2016, 12:02 AM
  2. Using Named range to populate a Combobox in userform
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2015, 09:57 PM
  3. [SOLVED] populate user form combobox based on dynamic range
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2015, 09:22 PM
  4. [SOLVED] Populate Userform ComboBox from range
    By Lasse Moe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2014, 12:47 PM
  5. In UserForm, how to populate a ComboBox/ListBox with a Range, defined by....
    By johnw993 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2012, 11:06 PM
  6. Populate a combobox in a userform with a dynamic range.
    By BigBas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2007, 01:12 PM

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