Checkboxes, selecting

I dont see what I am doing wrong. If I select checkbox1 I want checkbox3 to be false and vice versa, thats simple enough. Everytime I click on one or the other checkboxes I have to reselect the one I want.

It takes two clicks to get a checkbox checked (True).
My listbox will be populated by both lists in the "Checkboxes" code once I select a checkbox, then reselct to repopulate.

Checkboxes:

Please Login or Register  to view this content.

Initialize userform:

Please Login or Register  to view this content.

Any hints, tips or examples are appreciated.

Hi Rick

try something like

Please Login or Register  to view this content.

Confess I've not read through but saw Pike's and figured I'd be a smart-a$$ and say you could save some lines with

Please Login or Register  to view this content.

(and v-v re: cb3 event)

Have a good w/e.

No, less lines the better ....... I remember this

thanks DonkeyOte

Surely if checkbox1 and checkbox3 are mutally exclusive should they not be option buttons?

Originally Posted by Andy Pope

Surely if checkbox1 and checkbox3 are mutally exclusive should they not be option buttons?

Your not the first person to say this.
Option buttons it is.