+ Reply to Thread
Results 1 to 3 of 3

Excel Userform ComboBox Drop Down List Blank

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    2

    Excel Userform ComboBox Drop Down List Blank

    I've created a UserForm with several ComboBox drop down lists. They work when first created, pulling a list of referenced data utilizing the RowSource field. After some time, an issue arises where some of the drop down lists work, showing all the listed items, and others do not, showing a blank field.

    2020-05-13 08_37_20-UserForm2.png

    Any idea why this may be happening?

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Excel Userform ComboBox Drop Down List Blank

    are you feeding data back & forth to the sheet that populates the rowsource, if so you have probably confused the rowsource referencing.
    only use rowsource as your last option there are far more stable ways of loading comboboxes.
    see the big yellow banner at the head of the page, upload your workbook with a few rows of desensitised data.
    far easier to then pinpoint an answer for you,
    torachan.

  3. #3
    Registered User
    Join Date
    10-10-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel Userform ComboBox Drop Down List Blank

    Thanks, torachan.

    I believe I resolved the issue. The problem arose due to a worksheet being deleted and then re-added. This sheet housed all of the named references and those were broken upon deletion of the sheet. I've added back the name ranges and ensured they elapsed the entire workbook and it seems to alleviated my issue.

+ 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] Userform: Change Combobox list based on a second ComboBox selection
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-11-2016, 03:45 PM
  2. Userform Combobox - select from list, store this as default each time userform loads
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2014, 07:48 AM
  3. [SOLVED] How to use a list from Excel Sheet with Userform ComboBox
    By JRidge in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-26-2014, 09:04 AM
  4. [SOLVED] Make combobox list options dependant on selection in another combobox within a userform
    By Vladimir_Dobvchenko in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2013, 05:30 AM
  5. [SOLVED] Excel 2010--Blank List Wanted in Drop Down List
    By AgeOfEgos in forum Excel General
    Replies: 4
    Last Post: 08-15-2012, 03:13 AM
  6. Userform ComboBox ignore Blank Cells in list
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2011, 09:33 AM
  7. Userform Combobox value not returned when selected from drop-down list
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-12-2010, 03:59 AM

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