Change TabIndex on Userform Option Buttons

[AMAS]

Hi,

I have searched and can't seem to find an answer to this problem. I have a userform with Option Buttons. I have them all initialized as deactivated except for one at a time as the user performs certain tasks (e.g. Create a new worksheet with the name "database"). Once each task is completed, the previously activated option button becomes deactivated and another option button becomes activated. That works fine. My problem now is that I can't change the default tab index settings to put the black dot next to the activated option button:

This doesn't seem to work:

If Sheets("Database").Range("A1") <> vbNull Then
     Controls("OptionButton1").Enabled = False
     Controls("OptionButton1").TabIndex = 1 
     
     Controls("OptionButton2").Enabled = True
     Controls("OptionButton2").TabIndex = 0
End If

Any thoughts?

AMAS

 

[p45cal]

I don't understand: "put the black dot next to the activated option button" (rather than in it).
Do you mean have it as if that option is selected?
If so:
Controls("OptionButton2") = True
will do it.
Tabindex only decides in which order controls get the focus as the tab key is pressed repeatedly on the keyboard.

 

[AMAS]

Sorry about my poor explanation. You are correct. I did mean inside of it and your solution worked perfectly.

Thank you so much. I was overthinking the problem.

AMAS