I've got a form that may try to setfocus to a control that's not enabled.
So, I'm working on a sub to pass focus to the next sequential tabbed control.
I've tried to samples from outside threads,
the first one doesn't work and the second suggested solution won't compile.
I can't figure out why the compiler doesn't like the "{" for the TAB I want to send.
I've even tried copying the {TAB} from the MS help page for sendkeys.
I'm using a Latin keyboard, and the Region is set to Colombia.
I've tried the "[" and "(" to no avail.
I would like to avoid SendKeys, but the first suggestion that's commented out throws this RTE:
Application-defined or object-defined error
Post note: Okay, dummy me, needs to be in quotes.
Still, I would like to do it without SendKeys (love how it tabs in the VBA Editor while stepping through the code)