VBA macro to reproduce the F2 key in Excel

Hello everyone,

I would like to reproduce the F2 key on Excel via a VBA code.
The F2 key allows you to enter a cell and see the formula inside/the raw data.
Also, for a formula referring to cells, it shows where they are positioned with colours.
(Just press F2 on an Excel cell with a formula to see what I mean if it is not clear).

I tried the following code, but it does not work: ActiveCell.FormulaR1C1 = "=R[-1]C"

I thank you in advance for your help.

I wish you all a nice day.

Have you tried

SendKeys "{F2}"

It doesn't work..

Thanks Jec for your answer.

I used your code, it works but I do have the NumLock problem... Do you have any ideas how to remove the NumLock problem please?