For example

O Yes
O No

Next Cell

O Yes
O No

If i select the first Yes in the top cell and move to the next cell and
select No, then the top cell will clear and the bottom cell over rides it.

Hi,
Check out:
http://fontstuff.com/downloads/VBA04-UserForms.xls
Martin Green walks you through how to handle these kind of steps in building
a user form.

"stauff" wrote:

For example

O Yes
O No

Next Cell

O Yes
O No

If i select the first Yes in the top cell and move to the next cell and
select No, then the top cell will clear and the bottom cell over rides it.

You need to link the relevant controls and isolate them from the others. On the
Forms toolbar you will see what looks like a square with xyz at the top of it.
Click on that and drag a box around the controls you wish to group and these
will now operate independently of any other outside that box.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"stauff" wrote in message
...
For example

O Yes
O No

Next Cell

O Yes
O No

If i select the first Yes in the top cell and move to the next cell and
select No, then the top cell will clear and the bottom cell over rides it.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.784 / Virus Database: 530 - Release Date: 27/10/2004