Run macro when double click on cell

[aaronz07]

Hi,

How do I double click on a cell A1 and run a macro. And how do I double click on cell B2 to run a macro.

basically when I double click on separate cells a macro will run.

Thanks

 

[mole999]

have you thought of adding shapes over those cells

cell change events work, but double clicking a cell would only open it up for editing

you can assign macros to shapes very easily

 

[Ruddles]

double clicking a cell would only open it up for editing

If you do Cancel=True in the event handler, it doesn't go into edit mode.