Dear all,

I would like to know how to write the codes if I want to call a sub defined
in macro when double clicking a cell on the worksheet. I know that I can add
buttons on the worksheet, but I wonder if I can do the same thing by just
double clicking a cell.

I tried to record the macro, I got the following codes:

Range("A1").Select
ActiveCell.FormulaR1C1 = ""

Can anyone advise? Thanks a lot!

Ivan