In VBA, I would like to enter the Edit mode of a selected cell, and move the cursor to the start of the cell.
Via the keyboard, this is accomplished by F2 & Ctrl+Home, and I have been using this code:
SendKeys is causing a NumLock toggle issue
, and the advice is to avoid using SendKeys. However, an alternative is seldom suggested.
Can anyone please suggest a solution without SendKeys?
If not, do you know how to keep NumLock on, noting that putting SendKeys "{NUMLOCK}", True after the code just adds an extra toggle.
Via the keyboard, this is accomplished by F2 & Ctrl+Home, and I have been using this code:
Code:
SendKeys ("{F2}^{HOME}"), True
SendKeys is causing a NumLock toggle issue

Can anyone please suggest a solution without SendKeys?
If not, do you know how to keep NumLock on, noting that putting SendKeys "{NUMLOCK}", True after the code just adds an extra toggle.