Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
RCN
 
Posts: n/a
Default I need to create a simple checkbox that has true false outputs


  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default I need to create a simple checkbox that has true false outputs

You can use a check box from the forms toolbar:

Choose ViewToolbarsForms
Click on the Check box tool, to select it
Click on the worksheet, where you want the checkbox
With the check box selected, choose FormatControl
On the Control tab, enter a cell address in the Cell Link box
Click on the worksheet, away from the check box, to deselect it
Click on the check box, and a TRUE will appear in the linked cell

RCN wrote:

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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
Shorten a Macro mully Excel Discussion (Misc queries) 7 December 30th 05 05:52 PM
Help: runtime error - Method seriescollection object_chart failed huangx06 Charts and Charting in Excel 3 July 9th 05 12:27 AM
Hiding cells on condition Pennington Excel Worksheet Functions 19 April 21st 05 12:30 AM
Adding True False Results Arla M Excel Worksheet Functions 6 January 27th 05 06:29 PM
Grand Totals @ Same Place Amber M Excel Worksheet Functions 2 December 30th 04 07:13 PM


All times are GMT +1. The time now is 12:13 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"