Hi.
Is there a way to make the text cursor appear at the start, as opposed to at the end, of a cell when pressing F2 to edit it?
Hi.
Is there a way to make the text cursor appear at the start, as opposed to at the end, of a cell when pressing F2 to edit it?
Assign this short macro to a shortcut key:
![]()
Sub dural() Dim L As Long With ActiveCell L = Len(.Value) Application.SendKeys "{F2}" For LL = 1 To L Application.SendKeys "{LEFT}" Next LL DoEvents End With End Sub
Gary's Student
Why not use the Home key if you are to use sendkeys?
![]()
Application.SendKeys "{F2}{HOME}"
Hi Andy:
You are correct!
The idea did not occur to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks