Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005

    Unanswered: Using VB to change data validation

    This seems simple yet I am stumped. I have a drop down data validation in cell J1 that is a simple Yes or No. Starting in column C7, all cells have a drop down in them with a list of dept numbers.

    I simply want to try to limit the user to be forced to use this drop down list if the answer in cell J1 is Yes. If No, I want the user to be able to type in any department number they choose (3 digits).

    Any suggestions on how to set the data validation to either turn on or off based on results from J1?

    Using MS Excel Microsoft Office Standard 2010.


  2. #2
    Join Date
    Apr 2014
    Provided Answers: 23
    ooo..tricky. One method could be if J1=YES, then the cbo box is visible, (# limit)
    if no, cbo is invisible so they can enter any #.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts