+ Reply to Thread
Results 1 to 3 of 3

Userform combobox - setting up dependent values

  1. #1
    Registered User
    Join Date
    08-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    39

    Userform combobox - setting up dependent values

    Hello,

    I appreciate your time and expertise!

    I am looking to set up two combo boxes where the second combo box's values are derived from a table that is filtered based on the first combo box value.

    Here is a picture of the code that I am using: Combobox-dependentValues.JPG

    The set "Case" that is highlighted returns nothing in the second combobox, and the "Case" below returns the hidden and visible values. After the filter is applied, I am looking to only get the visible cells.

    The file is attached, and this section of the code is located in UserForm.Initialize.


    Thank you,

    Adam
    Attached Files Attached Files
    Last edited by adamstarr12; 11-25-2014 at 06:17 PM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Userform combobox - setting up dependent values

    Which form is the code for?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Userform combobox - setting up dependent values

    The InitialForm

+ 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] Dependent Combobox Userform
    By Frankinstyyn in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-15-2014, 03:21 PM
  2. [SOLVED] UserForm: ComboBox #2 dependent on ComboBox #1
    By TexasAggie12 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2014, 10:41 AM
  3. [SOLVED] Userform with two combobox dependent on one combobox
    By bigfoot007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2012, 01:01 PM
  4. VBA Userform Dependent Combobox
    By TextMonkey in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-10-2011, 06:46 AM
  5. userform one combobox dependent on another
    By busydave in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2010, 06:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1