Userform option buttons set to false

[c.davidson]

I have a userform with some option buttons, when the userform opens I would like all of the option button values set to false. If I run the code as normal then it always remembers my previous selection. But if I use step-in F8 on the code line by line then when the userform opens all of the values are set to false. Can anyone help with this?

Please Login or Register  to view this content.

[Keebellah]

Hi, place the code you have in the post in a module named Userform_Activate

[c.davidson]

Hi, place the code you have in the post in a module named Userform_Activate

Thank you, that's fixed the problem

[BadlySpelledBuoy]

In addition, if you have lots of OptionButtons you can clear them all by looping through rather than hardcoding them all.

Please Login or Register  to view this content.

BSB