Sub Rec()
AppActivate ("Form One")
SendKeys "{TAB}"
SendKeys "{9}"
End Sub

Hi Folks,

I am trying to create a string of code that takes values a user inputs onto the macro-based spreadsheet and inputs them into a window called "Form One"

AppActivate ("Form One")

this part of the code works great in that it activates the window "Form One"

The next part doesn't work at all. I am trying to use the "Tab" button to move the cursor to the next field and 'type' the number "9" but it isn't working at all. And by not working at all I mean that the macro selects the window "Form One" and then nothing happens.

The weird thing is, if I run the macro enough times (repeatedly hitting the "Start" box I have assigned the macro to), the Macro does tab over and type 9 into the next field.

Can someone please troubleshoot?

Thanks!