Option Button in Userform - how to unclick?

[rlee16]

In my Userform I have several option buttons that represent "And" and "Or". These are for a customized search (Users can choose criteria X and/or criteria Y).

After executing a search (by pressing a button), I would like to the user to be able to reset everything so that the user can conduct another search.

I do not know how to reset the option buttons so that neither "And" nor "Or" are clicked without having to completely reinitialize the userform. Any help?

Richard

 

[Stretchwickster]

You should be able to do:

OptionButton1.Value=False
OptionButton2.Value=False

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)