Uncheck checkbox2 when checkbox1 is checked

[tweek]

Hi, I've been trying to find a way to uncheck a checkbox when another one is checked. My VB coding isn´t very strong so I would really appreciate some help.

I´m thinking that a if statement would do the job, my checkboxes are checkbox1 and checkbox2 and are located in sheet1.

hope someone can help,
thank you very much for your time.

 

[RoryA]

If you want an either or option, then Optionbuttons do that automatically. (Checkboxes are more commonly used where more than option can be checked at a time.)

 

[tweek]

Thank you, it does exactly what I wanted. But is there any way to make the button square not round ?

 

[RoryA]

No, not that I'm aware of. It's generally better to try and keep a look and feel that is common to all windows applications, IMO.