'Do a basic double click on a cell using VBA ,other than using SendKeys "{F2}" [duplicate]
When you are working in Excel and double click on a cell,
it selects the cells and gives you a blinking cursor within the cell to enter values or a formula.
I tried the below code, It works ,But it turns off Num Lock on my keyboard (I do not know why) .
SendKeys "{F2}"
Appreciate for yours comments and answers.
Solution 1:[1]
It's a bug in VBA: SendKeys is messing with my NumLock key via VBA code in Access form
To workaround send NumLock:
SendKeys "{F2}"
SendKeys "{NUMLOCK}", True
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Xavier Junqué |