Deselect option button userform

  • 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

  • Hello,


    You could be testing the following macro:



    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • 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

  • Hello SugarBunny,


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

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!