Dropdown Menu List by a Macro?

omairhe

Well-known Member
Joined
Mar 26, 2009
Messages
1,971
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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

omairhe

Well-known Member
Joined
Mar 26, 2009
Messages
1,971
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,971
Office Version
  1. 2019
Platform
  1. Windows
Thanks Zack..
i'll let u know how it goes.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,388
Messages
5,601,376
Members
414,447
Latest member
CRAVIN

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top