G
Guest
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
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