software

I would like to know how to put a check box in my XLS worksheet, then I can
write

formula in an other cell B1 as quot;=IF (Checkbox(A1)=True, quot;OK, checkedquot;, quot;Not

checkedquot;)

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

You can show the Forms toolbar and add a checkbox to the worksheet.

But rightclick on that checkbox and select Format control.

Then use a cell link (adjacent to that checkbox??)

And then you can test that link:

=if(b3=true, quot;checkedquot;,quot;not checkedquot;)Tr Huynh wrote:
gt;
gt; I would like to know how to put a check box in my XLS worksheet, then I can
gt; write
gt;
gt; formula in an other cell B1 as quot;=IF (Checkbox(A1)=True, quot;OK, checkedquot;, quot;Not
gt;
gt; checkedquot;)
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions

--

Dave Peterson