This is the kind of functionality that Optionbuttons (nicely grouped) provides.

If you end up using optionbuttons from the Forms toolbar, put each group inside
a groupbox (also on the Forms toolbar).

If you end up using optionbuttons from the Control toolbox, you'll have to use a
different groupname for each set of optionbuttons in a group. (It's under the
properties window.)

You may want to look at Debra Dalgleish's site:
http://www.contextures.com/xlForm01.html

For some options with the optionbuttons from the Forms toolbar.

chefmike wrote:

I need some shlp please, I have 4 check boxes on the same line and would like
to be able to check one and if I change the check that it automatically
uncheckes the one that is already checked and checks the new one. In other
words if i have already checked the first box, and change my mind and then
check the third box, the first box should uncheck when the third is checked.

I am using excel 2003

Thanks chef mike

--

Dave Peterson