Results 1 to 5 of 5

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

Threaded View

  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.

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