Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Use of Check Boxes

I'm interested in using a check box in a column on a worksheet. I would like
to be able to toggle the check box on or off to include or exclude the check.

Where can I find the help instruction for doing this?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 143
Default Use of Check Boxes

I'm interested in using a check box in a column on a worksheet. I
would like to be able to toggle the check box on or off to include or
exclude the check.


One way is to start with the "Forms" tool bar. Make this appear by right-
clicking in the toolbar area and checking "Forms."

Click on the check box in the Forms tool bar and then click in the
spreadsheet. This should make a check box appear. You can move it around
and resize it.

Then, using
Right-click Format Control
you can change its appearance and behavior.

Most interesting is Format Control's "Control" tab. Using it, you can
assign a "Cell link," choosing a worksheet cell to store the state of the
check box (checked or not). This lets you do calculations based on this
state.

(I have Excel 2003.)
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
Check Boxes doss04 New Users to Excel 2 October 12th 08 04:02 PM
Check boxes MACAVITY500 Excel Discussion (Misc queries) 5 November 18th 06 01:47 PM
How do I increase the size of check in check boxes Adams, Les Excel Discussion (Misc queries) 0 September 19th 06 02:35 PM
Enable check box in protected sheet + group check boxes Dexxterr Excel Discussion (Misc queries) 4 August 2nd 06 12:00 PM
How do i create a value for check boxes or option boxes Tim wr Excel Discussion (Misc queries) 1 February 9th 06 10:29 PM


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