Excel 2007 : How to assign a macro to a cell?

[furiousfox]

Hi All
the cell D4 contain the number 4.
How do I execute a macro from that cell?

Thanks for your help.

Furiousfox

[Andy Pope]

You would need to use a worksheet event.

Either the selectionchange of change event.
You will need to test the Target cell is actually D4

right click sheet tab and View code.
paste the following.

Please Login or Register  to view this content.

When you select D4 the message will appear.

[furiousfox]

Hi
It's perfect!!!

Thank you