MS excell 2007 Data verification list

R

rmar

I am attempting to use the list function within data verification for drop
down menus. I need a list that is conditional upon the information in
another cell.
Example: The first cell offers a drop down menu with specific Make of
equipment. From what appears in that cell I seek to offer only the Models
for that Make of equipment on a list in another cell. I considered using a
series of IF statements to run macros however I don’t know how to invoke a
macro from within a formula. Any suggestions?
Thank You
=if(“Traneâ€,macro,=If(Crrier,macro,=If(Bitzer,macro…)))
 

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

Drop down list control value in vba 2
Formatted cell column in drop down list 1
SUM determined by drop-down list 9
data verification question 0
Drop down box w/contents of different worksheet? is this possible 1
IF statement reference 1
Multiple Dependent Drop Down 1
Drop Down List Dependant Formula 2

Top