Dropdown Menu List by a Macro?

[omairhe]

WHEN, Value Matches Z3=AC32:TJ32 , Then Dropdown menu on "AA3" with 'List' Source RangeName= the matched value "Z3=AC32:TJ32".

so if "dvd=dvd" which is a match , then Dropdown source RangeName= "dvd" on AA3
and if "cd=cd" a match , then Dropdown source RangeName= "cd" on AA3

this macro be Executed when pressed Enter or Tab on Cell Z3 or when AA3 is Active.Cell

if there is no data in Z3 then do nothing'

idea here is that Z3 is already a Dropdown menu and it filters the next drop menu (AA3) by adding the same |list source| VALUE that Z3 has.

will very much appreciate help.....

 

[omairhe]

Hi.
sorry guys but i don't seem to need the match criteria ... i had it confuse with some other macro....

so its real simple this way ....

When Value is entered in Z3 from either drop-down menu list or manually then a new drop down menu list is created by a macro automatically on the cell AA3 with list Range source of Value same as Z3.
if there is no data in Z3 then do nothing'

for instance i've given Range a Name "Memphis"
so if Z3 is "Memphis" then what i want is a Dropdown Menu List on AA3 to be having source name "Memphis".


Will appreciate help

 

[Zack Barresse]

Hi there,

If you name your ranges, you can just use something like INDIRECT(FirstDependentCellNameHere) as your List source for your dependent validation. If that doesn't make sense, do a board search for 'dependent validation'. There's plenty of material on here to show you. No macros required.

 

[omairhe]

Thanks Zack..
i'll let u know how it goes.

 

[Zack Barresse]

Here is a link which shows how you can setup a sheet which gives you an endless supply of dependent validation lists with just a few simple named ranges...

http://www.vbaexpress.com/forum/showthread.php?t=1072&highlight=data+validation+2000

HTH

 

[omairhe]

oh man that is kool also i checked this video http://www.youtube.com/watch?v=zKzPWz0Fg6U

Thanks a lot for the help