VBA to execute keystroke F2+enter

[derickz]

Hi All, from what I read from the Internet, having VBA executing the keystroke is not recommendable.

However, I also cannot get it done too.

I am very new to VBA and I am trying to pick up pieces, hope everyone could help out, thanks in advance!

I am using the manual keystroke to change the format of the date. F2, Enter, F2, Enter, repeat. I will have whole long list of data at times and I am thinking of writing a script to replace the manual entry. Macro recording cannot get this to work.

[alansidman]

Here is an alternative solution:

Please Login or Register  to view this content.