G Guest Feb 1, 2004 #1 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.
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 Feb 1, 2004 #2 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.
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.
