+ Reply to Thread
Results 1 to 4 of 4

How to modify a data validation conditional list?

  1. #1
    Registered User
    Join Date
    01-30-2012
    Location
    cairns
    MS-Off Ver
    Excel 2003
    Posts
    29

    How to modify a data validation conditional list?

    Hi,

    I have two cells (B2 & C2), both with drop down lists. The drop down list in C2 depends on the selection made in B2, this is all working fine. However, there is one extra step I need to add and I'm not sure how to do it.

    The list in B2 has an option "Other", when this is selected the user should be able to free type into C2 to specify their choice. However, with the data validation already active in C2 it won't allow this free typing.... How can we fix this? Is there a formula I can add to conditional formatting or something? Spreadsheet attached.

    Thanks,

    Willge
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: How to modify a data validation conditional list?

    You need to keep the formula for the dependant dropdown to work. You may have to use a worksheet change event. When you make a selection in B2 it kicks in. Copy and paste this code into the worksheet module.(right click on the sheet tab and select view code)
    Please Login or Register  to view this content.
    You will have to save the book as a macro enabled workbook.

  3. #3
    Registered User
    Join Date
    01-30-2012
    Location
    cairns
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: How to modify a data validation conditional list?

    Hi Dave,

    That works well, looks quite complicated so I'm glad for your help. If I'm already using code for a command button (below) can I just paste your code directly after it? Or will it need to be inserted somewhere in the middle?

    Please Login or Register  to view this content.
    - Will

  4. #4
    Registered User
    Join Date
    01-30-2012
    Location
    cairns
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: How to modify a data validation conditional list?

    (I would try it first except I'm overseas w/ no access to it at the moment, sorry!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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