Data Validation, Via A Formula

M

MWS1420

Is there a way to apply data validation to one cell, based on the result of
another cell? For instance, if in A1, a data validation list displays sports
(ie baseball, basketball,etc), and if the user selects "Baseball", then the
data validation in B1 would only list baseball teams, from the range named
baseball teams. And if basketball is selected, then only basketball teams are
displayed.

If at all possible, could this be done via a formula and WITHOUT using VB?
If not, I could also use any help to accomplish this via VB coding.

Any and all help will be appreciated - Thank You
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

unhide Rows when question is answered via a drop down box. 1
If formula and Data Validation parallely 1
checkboxes on forms that search criteria 1
Populating a data validation list based on criteria 3
Using Checkboxes to Search for records 1
A data validation question 1
Hide column based on data validation 0
Data Validation blanks for formulas 18

Top