How can I check (activate, select) an OptionButton with VBA?

Question

In my excel sheet I put 2 OptionButton objects:

in my VBA macro I added:

Sub OptionButtonDebugOff_Click()
    debugmode = False
End Sub
Sub OptionButtonDebugOn_Click()
    debugmode = True
End Sub

and associated the object with resp. OptionButtonDebugOff_Click and OptionButtonDebugOn_Click (right-click on the "button" -> assign macro).

Event handling works fine ('debugmode' variable is changed to False when I click on the 'OptionButtonDedugOff').

I haven't found the VBA command to set a value to those OptionButton's , in particular at macro start, to make the button associated with OptionButtonDedugOff_Click checked (selected) by default (knowing that, besides, debugmode is set false at macro start).

Thanks for your advises!

Possibly, worksheets("SheetName").Shapes("ButtonName").ControlFormat.Value= xloff or xlon — Nathan_Sav
– Nathan_Sav, Commented Oct 21 at 12:47
Thanks @Natthan_Sav. I haven't managed to make this working ; what is "ButtonName" ? I don't see a place to set a name to the object , in particular in the Format Control popup (right-click on the "button" -> Format Control ) — fabbb
– fabbb, Commented Oct 21 at 15:06
When you select your button, its name will appear in the Name Box on the left side next to the formula bar. — MGonet
– MGonet, Commented Oct 21 at 15:14
It may be e.g. "Option Button 1" or equivalent in your language. You can use either English or local name. — MGonet
– MGonet, Commented Oct 21 at 15:20

Nathan_Sav · Accepted Answer · 2025-10-21 16:40:09Z

2

You can use the following, replacing SheetName with your sheet name and ButtonName with the name of your Option Button name. This will be available just above where the top left cell is in Excel.

worksheets("SheetName").Shapes("ButtonName").ControlFormat.Value= xloff or xlon

answered Oct 21 at 16:40

Nathan_Sav

8,5762 gold badges18 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Becky Behn Oct 22 at 7:59

automateexcel.com/vba/cheatsheets

Becky Behn Oct 22 at 8:00

cheat sheet created from "Steve" I hope this aides you

Becky Behn · Accepted Answer · 2025-10-21 13:39:08Z

0

Are you using ControlFormat ?

Is your approach to work with shapes? Perhaps manipulate the OptionBotton sate, 'if' button inserted as a Form Control.

New here .. Curious did you modify the .value property of the OptionBotton object?

answered Oct 21 at 13:39

Becky Behn

11 bronze badge

2 Comments

Community Oct 21 at 13:58

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

fabbb Oct 21 at 15:02

I don't know the VBA commands to set the .value property of the OptionBotton object , this is actually my question.

Becky Behn · Accepted Answer · 2025-10-21 14:21:42Z

0

If your OptionButtons are in ControlFormat this where you manipulate state, I do believe

This of course would depend if depending on whether you want the OptionButton selected ? Can be set either x1on or x10ff

answered Oct 21 at 14:21

Becky Behn

11 bronze badge

Collectives™ on Stack Overflow

How can I check (activate, select) an OptionButton with VBA?

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related