Can macro return me to cell edit mode

G

Guest

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
 
Z

Zone

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}"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top