Togglebutton states

[AndyEd]

In a userform I have a number of togglebuttons that are in an 'unselected' state when the form loads. During the course of completion the user clicks on the togglebuttons to change their state to either 'true' or 'false', 'on' or 'off', '1' or '0', whichever way you want to look at it..

I want to incorporate a cmdbutton to reset the selections, from which I would like to have the togglebuttons revert to their 'unselected' state.

Is that possible? I have used 'null' as an option but that doesn't seem to work.

Any help would be appreciated.

 

[Skyybot]

You should be able to modify this to get the results you're looking for:

Sub unSelect()
Dim opb(), cnt As Control, i As Long
UserForm1.Show vbModeless
For Each cnt In UserForm1.Controls
    If TypeName(cnt) = "ToggleButton" Then
        ReDim Preserve opb(i)
        opb(i) = cnt.Name
        i = i + 1
    End If
Next cnt
For i = 0 To UBound(opb)
    UserForm1.Controls(opb(i)) = False
Next i

End Sub

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:
Set 'unselected' state for togglebutton

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[RoryA]

I have used 'null' as an option but that doesn't seem to work

Null is correct, assuming you have set the TripleState property to True.