Good afternoon Mike -
Getting A check box in a cell should be done using the Check BOX item on the FORMS Toolbar.
Go to the View Menu - Select the Toolbars menu - Select the Forms Toolbar
The check box is the third item down in the left column. Click on it and then click and drag in a cell in your sheet.
While it is still selected - go to the Format Menu and select Format Control - type in a Cell address that you want to
use to get the value of the checkbox - True is checked - false if unchecked.
Hope this helps -
Thanks,
Jon Barchneger
--------------------
| **From: "Mike M." <mcmdm50(eliminate this)@cox.net>
| **Subject: Check Boxes
| **Date: Tue, 4 Nov 2003 07:03:20 -0500
| **Lines: 14
| **X-Priority: 3
| **X-MSMail-Priority: Normal
| **X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| **X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| **Message-ID: <
[email protected]>
| **Newsgroups: microsoft.public.excel.worksheet.functions
| **NNTP-Posting-Host: ip68-0-244-141.ri.ri.cox.net 68.0.244.141
| **Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| **Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.worksheet.functions:169031
| **X-Tomcat-NG: microsoft.public.excel.worksheet.functions
| **
| **I would like to insert a checkbox into a cell, then when checked, create a
| **formula that reads
| **something like "If this boxed is checked, then enter a specified letter in
| **cell "A3".
| **1st things 1st.
| **The initial problem I am having is that after inserting the check box &
| **clicking on it, it does not enter a check mark.
| **Unless it cannot be done, I think I can figure the formula if someone can
| **help me with getting the box to check.
| **Thanks,
| **
| **Mike
| **
| **
| **
