View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Use VBA to open an Excel cell for Edit

Sub AAAtest()
Cells(1, 1).Select
SendKeys "{F2}"
End Sub

--
Regards,
Tom Ogilvy



Michael Gree wrote in message
...
Hi,
How do I open a cell for edit from code ie as if the user
had pressed F2...
Regards
Michael Green