Uncheck option buttons

[Oeysbrei]

Hi,

I was woundering if anyone could help with a code for unchecking option buttons by use of a maco.

Thanks in advanse.

[dominicb]

Good afternoon Oeysbrei

What kind of option button?
One that you have programmed yourself? There are a number of sorts.

From within a userform it would be as easy as :

Please Login or Register  to view this content.

to toggle the value on and off.

You will need to provide more information.

HTH

DominicB

[Oeysbrei]

Hello Dominicb,

I have attached a dummy workbook with a textbox explaning what I want.

[dominicb]

Hi Oeysbrei

Would you consider using AciveX controls rather than form controls?
They look better, are easier to control, are more modern etc.
They can be found on the same toolbar as form controls. There's no reason not to really.

DominicB

[Oeysbrei]

Hi,

I will still have the same problem by using ActiveX controles. I need a macrocode to get them unchecked by use of a button that also will clears the form.

Best regards Oeysbrei

[dominicb]

Hi Oeysbrei

Have a look at the example workbook, using ActiveX controls rather than form controls, doing what you require.

HTH

DominicB

[Oeysbrei]

Hi dominicb,

That will clear the buttons, but not the form. Do you have any code that I use in the same macro so that it will do both?
Hope you have patience with me, I`m new at this.

Oeysbrei

[Oeysbrei]

dominicb,

It`s working halleluja.
I had to change some of the words from my norwegian version to the english.

Thank you very mutch