+ Reply to Thread
Results 1 to 5 of 5

I need a ComboBox to return another Combobox if a specific answer is selected

  1. #1
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    107

    I need a ComboBox to return another Combobox if a specific answer is selected

    Hi,

    I received some help yesterday creating a combobox and a userform. In the combobox there is a drop down menu that when an answer is chosen is populates C2.

    What I require is another ComboBox to appear should the option: "None of the above" be selected from the first comboBox. This second combobox must have the list in A11-A17 and populate E2 with the answer.
    This second ComboBox must look identical to the first except the Question asked will NOT be "Is the Incident Driver the Regular Driver, the insured party or both?" but RATHER, "What is the relation to the insured party?" followed by a drop down.

    Now if in the first ComboBox "Insured", "Regular Driver", "Insured is Regular" is selected it needs to still populate C2 with the answer but in E2 it needs to write "Not Applicable"

    I have attached an excel file with the vba code I received help with yesterday and that should make things more clear.

    Thanks a million!!!
    Attached Files Attached Files
    Last edited by concatch; 03-07-2012 at 06:19 AM.

  2. #2
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Thumbs up Re: I need a ComboBox to return another Combobox if a specific answer is selected

    Hi concatch

    please find the attached excel file with solution
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    107

    Re: I need a ComboBox to return another Combobox if a specific answer is selected

    Thank you very much! It's almost what I require but there are a few bugs.

    1) If on the first combobox "none of the above" is selected it needs to insert this into C2 and then the second comboBox needs to appear.

    2) Once an answer is selected from the second comboBox it needs to place this in E2. It currently places it in C2.

    Thanks again!

  4. #4
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    107

    Re: I need a ComboBox to return another Combobox if a specific answer is selected

    Thanks I made the adjustments and it works!!!

  5. #5
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: I need a ComboBox to return another Combobox if a specific answer is selected

    Hello concatch

    Please mark "Solved" of Your Thread

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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