+ Reply to Thread
Results 1 to 2 of 2

Help with comobox linked to previous combobox (dependancy) on a userform

  1. #1
    Registered User
    Join Date
    05-21-2015
    Location
    Gauteng, South Africa
    MS-Off Ver
    2010
    Posts
    11

    Help with comobox linked to previous combobox (dependancy) on a userform

    Hi everyone,

    I am working on a summary report that starts by asking the user to provide it with a few key components with regards to the unit that was tested.

    There are two sections: info with regards to the unit that was tested and the second pertains to the results. I am having trouble with the first section. Upon opening the userform (HistoryInfo) the user should be able to select a unit operation from a dropdown list (combobox is linked to a named ranged "UnitOperation"). Until this point I am able to get the userform/combobox to work as I wish, it is the next section that I am having trouble with.

    Then the second dropdown should list the sizes that is available in the option that was selected in the first combobox. This should also be drawn from named ranges. The idea is that the comboboxes should have the same functionality as the INDIRECT() function, but it has to be on a userform. In a similar scenario, the advice was given to use a combobox along with a list box, but I dislike the idea since the list of available sizes differ. Any advice on how to get this to work will be much appreciated

    I have attached the summary file to show what I currently have and where it is that I need help. The userform is on the Information sheet and the named ranges is on the Names sheet.

    Please, help?

    TL33
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,974

    Re: Help with comobox linked to previous combobox (dependancy) on a userform

    Scratch Private Sub UOoption_Click() and Private Sub UOSize_Click()
    Replace with:

    Please Login or Register  to view this content.
    Ben Van Johnson

+ 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] Change next ComboBox list based on previous ComboBox selection
    By SteveTheFish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2015, 11:23 PM
  2. [SOLVED] UserForm ComboBox linked values
    By PDBartlett in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-08-2014, 09:53 AM
  3. [SOLVED] VBA Userform: Use value from Comobox to populate a Listbox
    By devolg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2013, 11:59 PM
  4. Refresh UserForm to display data that is linked to combobox selection
    By alter54 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2012, 01:30 PM
  5. userform combobox rowsources chosen by heading match to previous comboxbox selection
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2009, 02:38 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