Change Multiple Drop Down Lists Simultaneously

[abaxter]

I have a list of 1000+ drop down lists (all containing the same options). I need to change the selection for all lists. is there a way to do this that doesn't require changing them one at a time?

Thanks!

 

[mikerickson]

What kind of drop downs are you using? Validation, Forms menu, Active X?
and what is the Source for those controls?

 

[abaxter]

What kind of drop downs are you using? Validation, Forms menu, Active X?
and what is the Source for those controls?

Validation.. the source is on the same sheet.

 

[FDibbins]

If you want them all to show the same thing, why use DD's?

Use the DD for the 1st 1, then, instead of using the other DD's, just reference that cell for where you have all the other DD's

 

[mikerickson]

Select a cell that has validation.
Invoke the Validation dialog box.
Check the box that says "Apply these changes to all other cells with the same settings"

Make your changes

 

[FDibbins]

Mike, wont that just apply that cell's DD settings to the other DD's? I think OP wants to select "apple" in 1st DD and have all other DD's to also then have "apple" selected
(could ne totally wrong though lol)

 

[mikerickson]

I interpreted the OP that currently he has 1000 cells with options "apple,banana,pear" and he wants 1000 cells with options "Able,Baker,Charlie".

"I need to change the selection for all lists" can be interpreted many ways.

I don't think VB is required for most of the possible interpretations, unless the OP want to increment the current selection by the same amount,
e.g. all "apple" > "banana" all "banana" > "pear" "pear">"apple"

I trust that abaxter will tell us what it is he wants.

 

[FDibbins]

haha yup, you could be right, hopefully the OP will clear up the matter