Go to next + run macro

[xatomicx]

Hi everyone,

i need to make a macro to automatize a series of command.

I have a drop down menu in d4, this drop down include a list of names, once i select a name it will load for about 15 seconds (as it is pulling off data), once its complete i press a "save to pdf" button wich call a macro "RangeToPdf".

i want to automatize all that so i dont need to go pick the name one by one in the menu, wait, and click the button.

Can this be done? i can of course, post the file if this is unclear.

[Norie]

How is the dropdown menu populated?

[xatomicx]

trough data validation, located in $T$3:$T$64

[mgs73]

Try This:

Please Login or Register  to view this content.