Dropdown Menu List by a Macro?

omairhe

Well-known Member
Joined
Mar 26, 2009
Messages
1,954
Office Version
  1. 2019
Platform
  1. Windows
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.....
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

omairhe

Well-known Member
Joined
Mar 26, 2009
Messages
1,954
Office Version
  1. 2019
Platform
  1. Windows
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

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
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

Well-known Member
Joined
Mar 26, 2009
Messages
1,954
Office Version
  1. 2019
Platform
  1. Windows
Thanks Zack..
i'll let u know how it goes.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,569
Messages
5,572,979
Members
412,491
Latest member
tweetytoon
Top