View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
 
Posts: 143
Default How do i click on a cell for a tick symbol to appear & dissapear?

As in checking things off (a tick) in that particular column...I am
using microsoft excel 2003.


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.