Do a basic double click on a cell using VBA ,other than using SendKeys "{F2}"

Question

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.

score 2 · Accepted Answer · answered Mar 15 '22 at 13:58

2

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

answered Mar 15 '22 at 13:58

Xavier Junqué

350
2
5

It works right now – Waleed Mar 15 '22 at 14:02

Do a basic double click on a cell using VBA ,other than using SendKeys "{F2}"

1 Answers1