SendKeys command to select an OptionButton

[Fred Russell]

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 Ogilvy]

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

SendKeys "{TAB}{TAB}~"

 

[Jean-Yves]

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]

Hi Jean-Yves,

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

Thanks,
Fred

 

[Fred Russell]

Tom,

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

Thanks,
Fred

 

[Tom Ogilvy]

This worked in Excel itself - (sending a space)

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

 

[Fred Russell]

Tom,

Your a genius, the space works!

Thanks,
Fred