View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Khaled Khaled is offline
external usenet poster
 
Posts: 11
Default 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