Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
jamphan
 
Posts: n/a
Default Can Not Check more than 1 check box


I have a series of check boxes on a template. What I would like is for
the user to be able to select only one check box and possibly a message
box would appear if they tried to select more than one. Is this
possible?


--
jamphan
------------------------------------------------------------------------
jamphan's Profile: http://www.excelforum.com/member.php...o&userid=20105
View this thread: http://www.excelforum.com/showthread...hreadid=539294

  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default Can Not Check more than 1 check box

You should be using OptionButtons rather than CheckBoxes. With
OptionButtons, only one may be selected at a time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jamphan"
wrote in message
...

I have a series of check boxes on a template. What I would
like is for
the user to be able to select only one check box and possibly a
message
box would appear if they tried to select more than one. Is
this
possible?


--
jamphan
------------------------------------------------------------------------
jamphan's Profile:
http://www.excelforum.com/member.php...o&userid=20105
View this thread:
http://www.excelforum.com/showthread...hreadid=539294



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
... Can I set Spell Check to automatically check my spelling ... Dr. Darrell Setting up and Configuration of Excel 0 March 21st 06 08:26 PM
Can you sort with check boxes? Q Excel Discussion (Misc queries) 3 November 10th 05 08:11 PM
check boxes - copy MarkT Excel Discussion (Misc queries) 2 October 20th 05 04:33 PM
How do I use a check box to accept a calculation Joejoethecrackman Excel Discussion (Misc queries) 5 March 22nd 05 08:47 PM
Creating a check box that does not require security clearance. Maverick2U Excel Worksheet Functions 6 December 14th 04 02:46 AM


All times are GMT +1. The time now is 05:21 PM.

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

About Us

"It's about Microsoft Excel"