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
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)
Do not hesitate to post your comments ... or your remarks ..:wink: