Is there a way for VBA to leave a cell in edit mode?

[Jeffrey Smith]

I'm trying to create multiple data validations for cells. I want the user to be in edit mode after the macro finishes. And it would be nice to place the cursor on a specific character. Any hints?

Jeff

 

[Kenneth Hobson]

Horror of horrors, explore SendKeys().

 

[Jeffrey Smith]

yeah, well, um..... Thanks $MS for nothing! :~/

if I have to

 

[Rick Rothstein]

yeah, well, um..... Thanks $MS for nothing! :~/

if I have to

Using DoEvents coupled with the two SendKeys calls seems to leave the NumLock in the same state it was in when the code was first run. Give it a try...

Sub LeaveInEditModeBeforeFifthCharacter()
  Dim Char As Long
  Char = 4  ' 5 for fifth character and -1 to move in front of that character
  Range("E3").Select
  SendKeys "{F2}", True
  DoEvents
  SendKeys "{Left  " & Len(ActiveCell.Text) - Char & "}", True
  DoEvents
End Sub