Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 29th 04, 08:53 PM
stauff
 
Posts: n/a
Default How do I stop other circles in other cells to stop selecting?

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.

  #2   Report Post  
Old October 29th 04, 09:01 PM
mzehr
 
Posts: n/a
Default

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.

  #3   Report Post  
Old October 29th 04, 09:02 PM
Ken Wright
 
Posts: n/a
Default

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
selecting cells Wazooli Excel Discussion (Misc queries) 3 January 11th 05 09:53 PM
Hightlighting crosshairs when selecting cells JCF Excel Discussion (Misc queries) 1 January 11th 05 09:08 PM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
In Exel 2000, stop the blank cells (with formulas) from printing. tonyoc Excel Discussion (Misc queries) 1 December 10th 04 12:38 AM
How do I stop other circles in other boxes to stop selecting? stauff Excel Worksheet Functions 1 October 28th 04 10:27 PM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017