+ Reply to Thread
Results 1 to 2 of 2

Userform ComboBox not populating with external Range

  1. #1
    Registered User
    Join Date
    12-15-2014
    Location
    Wales, UK
    MS-Off Ver
    365
    Posts
    66

    Userform ComboBox not populating with external Range

    I have a userform with 2 comboBoxes on that needs to get it's named ranges from an external workbook.
    The Useform show without any errors, but the comboBoxes are empty.
    I added as much code as might be needed below and marked the sections I think might be the problem in bold red

    Any suggestion will be greatly appreciated.


    Code as follows (Shows "main" sub that's calling userform and namedRanges, as well as the subs for the userform and named ranges)
    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    12-15-2014
    Location
    Wales, UK
    MS-Off Ver
    365
    Posts
    66

    Re: Userform ComboBox not populating with external Range

    I received an answer on a different website. Link https://stackoverflow.com/questions/...09480_61077956

    To sum up the problem:
    • I had to move the FrmVendor_Initialize procedure the the UserForm code (I actuall removed the intitialize procedure all together)
      Main thing was to change the .tag that sets the address for the comboboxes
      Had to move the variables to get the info from the comboboxes into the New FrmVendor code above it
      I moved all the sub procedures connected to the userform into the Userform code (I know it's not neccessary but made things easier for my code)

    Main code that needed to change:
    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. Replies: 3
    Last Post: 03-22-2018, 11:25 AM
  2. [SOLVED] Populating and Displaying Combobox in userform
    By ActuaryInTraining in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2014, 12:42 AM
  3. Populating Userform ComboBox Using Items from Content Control Combobox
    By anarxo in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2014, 01:00 PM
  4. [SOLVED] Populating Combobox with another combox in same userform
    By DataVanMan in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 11-12-2012, 04:16 PM
  5. Userform: ComboBox Automatically Populating
    By ashleys.nl in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-14-2011, 09:43 AM
  6. Populating a userform based on a combobox selection
    By blindzero678 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2010, 03:37 PM
  7. Populating a ComboBox in a UserForm
    By I Maycotte in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2006, 01:28 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