Macro and Edit key

A

Armand

having trouble in using edit function in a marcro. Basically want the Macro to edit a cell, and a digit and close. Cannot get the edit "f2" key to work.
 
C

Chip Pearson

Armand,

VBA won't run when you edit a cell. You might try something like

Range("A1").Value = Range("A1").Value & "1"

This will add the digit 1 to the end of the value in cell A1.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


Armand said:
having trouble in using edit function in a marcro. Basically
Click to expand...
want the Macro to edit a cell, and a digit and close. Cannot get
the edit "f2" key to work.
 
Top