I'm using a closed 3rd party addin that I want to automate with the SendKeys
command. How can I "select" one OptionButton over another? Changing focus
with the SendKeys "{TAB}" works just fine but there doesn't appear to be any
combination of keystrokes that will actually move the "dot" from one
OptionButton to the other.

What am I missing?

Thanks,
Fred

Have you tried the enter key after the focus is shifted to the option
button.

SendKeys "{TAB}{TAB}~"

--
Regards,
Tom Ogilvy

"Fred Russell" wrote in message
...
I'm using a closed 3rd party addin that I want to automate with the
SendKeys
command. How can I "select" one OptionButton over another? Changing
focus
with the SendKeys "{TAB}" works just fine but there doesn't appear to be
any
combination of keystrokes that will actually move the "dot" from one
OptionButton to the other.

What am I missing?

Thanks,
Fred

Tom,

Tried it, doesn't work. Seems like there should be a way.

Thanks,
Fred

Hi Fred,

On the control properties window, Give a value for the "accelerator". The
letter you use
will be underligned in the control label.
Using ALT + the underligned letter should changed its value to True.
Regards
Jean-Yves

"Fred Russell" wrote in message
...
I'm using a closed 3rd party addin that I want to automate with the
SendKeys
command. How can I "select" one OptionButton over another? Changing
focus
with the SendKeys "{TAB}" works just fine but there doesn't appear to be
any
combination of keystrokes that will actually move the "dot" from one
OptionButton to the other.

What am I missing?

Thanks,
Fred

Hi Jean-Yves,

Unfortunately, the software is closed and I'm unable to assign an
accelerator.

Thanks,
Fred

This worked in Excel itself - (sending a space)

Private Sub CommandButton1_Click()
SendKeys "{Tab}{Tab} "
End Sub

--
Regards,
Tom Ogilvy

"Fred Russell" wrote in message
...
Hi Jean-Yves,

Unfortunately, the software is closed and I'm unable to assign an
accelerator.

Thanks,
Fred

Tom,

Your a genius, the space works!

Thanks,
Fred