macro executed by drop-down list. how?

[waldymar]

Hi,
I have a macro which output depence on the variable input. Input is represented by drop-down list. Before, I was choosing input from drop-down, then pressing the button my macro was running. Now, I'm thinking to if it's possible to exclude a spare operation from button pressing, just by clicking from drop-down. Any ideas?
My drop-down list is created through "Data->Validation->List box"

 

[Wayne01]

Lenze

I just stumbled upon this thread and have tried to use the code in excel 97 but without muck luck. Should it work in 97?

If possible, I too would like to run a macro from a change in a specified cell's value from a drop down list using 97.

Thanks

Wayne

 

[lenze]

Sorry, the DV list will not trigger a change_event in Excel 97.

lenze