Use VBA to open an Excel cell for Edit
Tom,
Thanks for that.
The reason I want the cell open for editing is as a nicety
for the user. Before this last line of code there is code
to insert a new row, specially format it with validation
etc. I then position the active cell so the user can
start entering data.
Regards
Michael Green
-----Original Message-----
You can only edit in the active window, so that shouldn't
be an issue.
I am not sure why you want to do this, but if you want to
change the value
in a cell, you certainly don't need to put excel into
edit mode (where code
doesn't run anyway).
--
Regards,
Tom Ogilvy
Michael Green wrote in
message
...
Tom,
Many thanks for that - it worked.
However I'm concerned that SendKeys only works on the
Active window. Do you know a way to ensure the key
strokes go to the correct window ?
Regards
Michael
-----Original Message-----
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
.
.
|