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

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