+ Reply to Thread
Results 1 to 3 of 3

Populate ComboBox from Dynamic Range

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

    Populate ComboBox from Dynamic Range

    Hi all,

    I've used the procedure below to populate UserForm ComboBoxes with dynamic ranges before but now the box is not getting loaded with the values from the range. I can't see where the problem is.

    Please Login or Register  to view this content.
    I've also tried an array version of this procedure. This version is also used to populate some dependent ComboBoxes elsewhere in the code and works for them.

    Please Login or Register  to view this content.
    I can't see where the problem is. Ultimately several combo-boxes on the form will be populated with the same list. A copy of my project is attached. Thanks for all the help.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Populate ComboBox from Dynamic Range

    The UserForm_Initialize procedure is always called UserForm_Initialize regardless of the UserForm's name. You had renamed it UsrFrm_ChemicalMaintenance_Initialize. So your Initialize procedure wasn't running.

    Try this...

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 03-27-2018 at 03:10 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

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

    Re: Populate ComboBox from Dynamic Range

    sigh. Thanks. I knew it would be some silly mistake. I forgot that. Thanks. I'll get there!

+ 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 from Dynamic Range
    By TFiske in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2018, 09:57 AM
  2. [SOLVED] Populate Texbox based from Combobox selection having applied dynamic range and adv filter
    By Amita68 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2017, 03:23 PM
  3. [SOLVED] How do I populate a specific range in one ComboBox based of selection of another ComboBox?
    By gmr4evr1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-04-2015, 04:32 PM
  4. [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
  5. [SOLVED] Dynamic Independent ComboBox - Populate TextBox
    By Raylou in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2015, 04:28 AM
  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