Hello

I need to select individual dropdown menu items and run some analysis, save
the results and then change the dropdown menu item and rerun analysis and
save the results and so on and so on. How do I reference individual dropdown
menu items? Thanks.

Brett

Sorry about the double-post folks. It tool a while for the first one to
appear and I was having problems so I thought it hadn't been received.

"FuadsCurse" wrote:

Hello

I need to select individual dropdown menu items and run some analysis, save
the results and then change the dropdown menu item and rerun analysis and
save the results and so on and so on. How do I reference individual dropdown
menu items? Thanks.

Brett

By using a named list in your Data Validation cell. Type the list in some
out-of-the-way range or in another sheet. Name that range say "TheRange".
Now set up the Data Validation cell by selecting the cell, click on
Data - Validation. Select List. Type "=TheRange" without the quotes. You
can access the individual items that make up the list, change them, add or
delete items, and reset the TheRange range and name it again. HTH Otto
"FuadsCurse" wrote in message
...
Hello

I need to select individual dropdown menu items and run some analysis,
save
the results and then change the dropdown menu item and rerun analysis and
save the results and so on and so on. How do I reference individual
dropdown
menu items? Thanks.

Brett

So how do I reference the individual items in the macro? That is, how do I
change the scenario each time? Sorry for my denseness ...

"Otto Moehrbach" wrote:

By using a named list in your Data Validation cell. Type the list in some
out-of-the-way range or in another sheet. Name that range say "TheRange".
Now set up the Data Validation cell by selecting the cell, click on
Data - Validation. Select List. Type "=TheRange" without the quotes. You
can access the individual items that make up the list, change them, add or
delete items, and reset the TheRange range and name it again. HTH Otto
"FuadsCurse" wrote in message
...
Hello

I need to select individual dropdown menu items and run some analysis,
save
the results and then change the dropdown menu item and rerun analysis and
save the results and so on and so on. How do I reference individual
dropdown
menu items? Thanks.

Brett