Can macro return me to cell edit mode
 

Can a macro after it runs return me to a cell in edit mode?
I made "rong entry of cell" runs a macro deponds on a cell that is
calculated (i used calculate event) and i don't want to delete the cell
contents but just edit in it instead of writing the whole entry agian
If i don't delete the entry in the biginning of macro it runs continously
until i break it
thanks

Can macro return me to cell edit mode
 

Please post your code.
--
HTH,
Barb Reinhardt



"Khaled" wrote:

Can a macro after it runs return me to a cell in edit mode?
I made "rong entry of cell" runs a macro deponds on a cell that is
calculated (i used calculate event) and i don't want to delete the cell
contents but just edit in it instead of writing the whole entry agian
If i don't delete the entry in the biginning of macro it runs continously
until i break it
thanks

Can macro return me to cell edit mode
 

You can put this in before your End Sub statement, but realize you won't be
able to run any code while you're in edit mode. James

SendKeys "{F2}"

"Khaled" wrote in message
...
Can a macro after it runs return me to a cell in edit mode?
I made "rong entry of cell" runs a macro deponds on a cell that is
calculated (i used calculate event) and i don't want to delete the cell
contents but just edit in it instead of writing the whole entry agian
If i don't delete the entry in the biginning of macro it runs continously
until i break it
thanks

Can macro return me to cell edit mode
 

Thank you very
simple and right answer but great thanks

"Zone" wrote:

You can put this in before your End Sub statement, but realize you won't be
able to run any code while you're in edit mode. James

SendKeys "{F2}"

"Khaled" wrote in message
...
Can a macro after it runs return me to a cell in edit mode?
I made "rong entry of cell" runs a macro deponds on a cell that is
calculated (i used calculate event) and i don't want to delete the cell
contents but just edit in it instead of writing the whole entry agian
If i don't delete the entry in the biginning of macro it runs continously
until i break it
thanks