How to enter in Edit Mode programmatically
 

--
Stefano Gatto

How to enter in Edit Mode programmatically - my question
 

I would like to create a short macro that appends the current date and the
initials of the Excel user, at the end of the text contained in a cell. This
will help identifying who wrote what, in a comment column. Ideally I would
like that the user finds the cell in edit mode after s/he runs this macro, so
s/he can enter text right away, instead of needing to click on F2.

Can a macro end while a cell is in edit mode?

Stefano Gatto

How to enter in Edit Mode programmatically - my question
 

Sub editmode()
Set r = Range("A1")
r.Value = "hello world"
r.Select
Application.SendKeys "{F2}"
DoEvents
End Sub

--
Gary''s Student - gsnu200837