Coding For The Return Key

Hello, what is the proper coding in vba that executes the keyboard's 'Return' or 'Enter' key?

And also, would the 'F' keys be represented as they are in vba eg. F5, F8, F10 etc. ?

I want to run a code that will execute 'F5' followed by the 'Enter' or 'Return' key.

Thanks for any help on this...

Originally Posted by Mhz

Hello, what is the proper coding in vba that executes the keyboard's 'Return' or 'Enter' key?

And also, would the 'F' keys be represented as they are in vba eg. F5, F8, F10 etc. ?

I want to run a code that will execute 'F5' followed by the 'Enter' or 'Return' key.

Thanks for any help on this...

untested, but try

Application.SendKeys("F5")

Application.SendKeys("~")

or

Application.SendKeys("ENTER")

for the numeric keypad enter.

hth
---

Hi,

Application.SendKeys "{F5}", True
Application.SendKeys "{ENTER}", True

Glad it fixed your problem

Thanks for the feedback