Deselect option button userform

ItsSugarBunny · Aug 2nd 2018

hello, can someone help me with the code to deselect all option button in a userform after submit (using commandbutton) the data.
so, i have a userform with 2 option button inside, lets say i submit the first data with optionbutton1 selected, and without closing the userform i want to submit another data without optionbutton1 nor optionbutton2 selected. what is the code for it? THANKYOU IN ADVANCE!
like in another case for example, in TEXTBOX, to make the textbox remain blank after submit a data without closing the userform you give code under cmbsubmit_click event likewise : txtName= " ". So the textbox will be blank after you click submit button. i wonder when it comes to option button, the code would as simple as that

**Carim** · Aug 2nd 2018

Hello,

You could be testing the following macro:

Code

Private Sub CommandButton1_Click()
Dim Ctrl As Control
  For Each Ctrl In Me.Controls
    If TypeOf Ctrl Is MSForms.OptionButton Then
            If Ctrl.Value Then
                Ctrl.Value = False
                Exit For
            End If
        End If
  Next Ctrl
End Sub

Display More

Hope this will help

rabsofty · Aug 2nd 2018

if your option buttons are in a frame, another quick way is to set and unset a button
(option buttons act as a group of option buttons in a frame - when one is true, the other(s) go false)
eg:
optionbutton1=true
optionbutton1=false

**Carim** · Aug 3rd 2018

Hello SugarBunny,

Do not hesitate to post your comments ... or your remarks ..:wink:

Deselect option button userform

Participate now!

Share