Autorun macro on change of cell value

[drazeni]

I have a macro recorded which I need to autorun when a specific cell in the spreadsheet changes (dropdown box).

Unfortunately I cannot find a method to run this macro automatically when the cell value changes.

Anyone got any ideas?

"All is not as it seems"

 

[TonyJollans]

Hi drazeni,

You will need to put your code in the Worksheet Change event. In the Sheet's Code Module, select Workshhet from the dropdown at the top left and Change from the one at the right. Put your code inside the (generated) procedure possibly subject to a test that Target intersects with your cell(s).

if you have any further questions on this, do please post back but they really belong in the VBA Forum

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.