software

Hi all

A colleague of mine has a worksheet and when she enters a 1 into a cell, a
tick is automatically entered into a checkbox in another cell next door.

The person who created this workbook no longer works for the company and we
now have to replicate this.

Any idea how he has created it???

Any urgent help would be much appreciated.
Thank you.
Louise

One way:

Set the font to Wingdings for the cell where the tick is to appear put this
formula there

=IF(A5=1,CHAR(252),quot;quot;)

changing the A5 reference to the cell where you are to enter the 1.quot;Louisequot; wrote:

gt; Hi all
gt;
gt; A colleague of mine has a worksheet and when she enters a 1 into a cell, a
gt; tick is automatically entered into a checkbox in another cell next door.
gt;
gt; The person who created this workbook no longer works for the company and we
gt; now have to replicate this.
gt;
gt; Any idea how he has created it???
gt;
gt; Any urgent help would be much appreciated.
gt; Thank you.
gt; Louise

There a few things you need to do. The first is to make sure you have the
forms toolbar in operation. Viewgt;Toolbarsgt;Forms. Then select the tick/check
box from your forms toolbars. Now right click on the check box and click
format control. Select your linked cell and click OK. now when you check the
box with your mouse you will notice there is a TRUE value in the cell you
chose to be your linked cell and if you uncheck it there will be a FALSE
value. Let's say you chose B1 as your linked cell, in B1 enter,
=IF(A1=1,TRUE,FALSE) Now when you enter 1 in A1 your box will be checked, if
there is not a 1 the box will be unchecked.

Hope this has helped

SPL
quot;Louisequot; gt; wrote in message
...
gt; Hi all
gt;
gt; A colleague of mine has a worksheet and when she enters a 1 into a cell, a
gt; tick is automatically entered into a checkbox in another cell next door.
gt;
gt; The person who created this workbook no longer works for the company and
we
gt; now have to replicate this.
gt;
gt; Any idea how he has created it???
gt;
gt; Any urgent help would be much appreciated.
gt; Thank you.
gt; Louise
Hi
Thank you for your help.
The only problem is, they want the actual checkbox style, not just a tick.
I think I have got around it by using the Forms method, adding a checkbox and
then applying a Cell to it - that seemed to work.

Thanks any way.
Louise

quot;Duke Careyquot; wrote:

gt; One way:
gt;
gt; Set the font to Wingdings for the cell where the tick is to appear put this
gt; formula there
gt;
gt; =IF(A5=1,CHAR(252),quot;quot;)
gt;
gt; changing the A5 reference to the cell where you are to enter the 1.
gt;
gt;
gt; quot;Louisequot; wrote:
gt;
gt; gt; Hi all
gt; gt;
gt; gt; A colleague of mine has a worksheet and when she enters a 1 into a cell, a
gt; gt; tick is automatically entered into a checkbox in another cell next door.
gt; gt;
gt; gt; The person who created this workbook no longer works for the company and we
gt; gt; now have to replicate this.
gt; gt;
gt; gt; Any idea how he has created it???
gt; gt;
gt; gt; Any urgent help would be much appreciated.
gt; gt; Thank you.
gt; gt; Louise

Worked a treat, thank you.

Louise

quot;PH NEWSquot; wrote:

gt; There a few things you need to do. The first is to make sure you have the
gt; forms toolbar in operation. Viewgt;Toolbarsgt;Forms. Then select the tick/check
gt; box from your forms toolbars. Now right click on the check box and click
gt; format control. Select your linked cell and click OK. now when you check the
gt; box with your mouse you will notice there is a TRUE value in the cell you
gt; chose to be your linked cell and if you uncheck it there will be a FALSE
gt; value. Let's say you chose B1 as your linked cell, in B1 enter,
gt; =IF(A1=1,TRUE,FALSE) Now when you enter 1 in A1 your box will be checked, if
gt; there is not a 1 the box will be unchecked.
gt;
gt; Hope this has helped
gt;
gt; SPL
gt; quot;Louisequot; gt; wrote in message
gt; ...
gt; gt; Hi all
gt; gt;
gt; gt; A colleague of mine has a worksheet and when she enters a 1 into a cell, a
gt; gt; tick is automatically entered into a checkbox in another cell next door.
gt; gt;
gt; gt; The person who created this workbook no longer works for the company and
gt; we
gt; gt; now have to replicate this.
gt; gt;
gt; gt; Any idea how he has created it???
gt; gt;
gt; gt; Any urgent help would be much appreciated.
gt; gt; Thank you.
gt; gt; Louise
gt;
gt;
gt;