That does it. Thanks, Mike!

"Mike H" wrote in message
...
I may be missing something but my point remains the same, what is the OP
actually trying to do? If you want a macro to active edit mode on a cell
paste this in, put a button on the worksheet to call it:-

Sub stance()
SendKeys "{F2}"
End Sub

Mike


"David Hilberg" wrote:

I thought I would start recording a macro, hit F2 to enter edit mode,
then stop recording to see what the VBA code was, but you cannot stop
recording a macro while in edit mode.

How modal.

- David

Zone wrote:
Is there a way in VBA to put the active cell into edit mode and to
cancel
edit mode? TIA, James