VBA - Determining what radio button is selected

[HedgePig]

Hello

I have a spreadsheet which has a lot of controls in it option buttons and checkboxes.
In VBA, how do I determine what the currently selected button is? I'm wanting to do something like

Activecontrol.Value = FALSE

Basically, I'm wanting to allow the user to reset an option button to "unselected". This can't be done directly by because once you've selected an option button you can only "unselect" it by choosing another option button in the same group. I want the user to be able to clear all selections in the group. I aim to achieve this by having a command button which when pressed would unselect the previously selected option button setting its value to "FALSE".

I realise I may have a problem here because by clicking the command button, the previously selected option button will no longer be zero. I can get around this by running the macro using shortcut keys. Or maybe there is also a way of easily what the last-but-one selected button is?

Any suggestions?

Regards
HedgePig

 

[Ivan F Moala]

Assign code to button .... resets all Optionbuttons

Dim sh As Shape

For Each sh In ActiveSheet.Shapes
    If sh.FormControlType = xlOptionButton Then
        sh.OLEFormat.Object.Value = False
    End If
Next

 

[HedgePig]

Hello Ivan

Thanks for your reply - sorry I missed it earlier!

What you are suggesting will reset ALL the options buttons. I'm simply wanting to reset whatever option button is currently selected. But I don't know how to identify what control is currently selected.

Regards
HedgePig