software

Is it possible to have the checkbox value (either checked or unchecked)
dependent on if the number in another cell is positive or negative (greater
than or less than zero)?

I've tried the quot;cell linkquot; option on the quot;controlquot; tab of the format control
popup menu, but it doesn't return what I want. It seems to do the opposite.
It takes the value of the checkbox and returns a true or false in the linked
cell. Is there a way to reverse it?

I'm using this on an expense voucher form and the checkbox indicates if the
final balance due (after deducting any advanced monies) is payable to the
company (negative balance) or payable to the employee (positive balance).

Any help is appreciated. Using Excel 2002 with Windows XP Professional.

Hi,

Am not sure if this is possible with Checkbox created using Forms
toolbar, but i have got a workaround.

Enter the following simple formula in the cell (Say B1) , where you want
the Checkbox :

=IF(A1gt;0,quot;aquot;,quot;quot;) where A1 is the cell which has got the positive or
negative number.

And then format the cell B1 to the Font called 'Marlett'.

Now, when A1 is more than 0, B1 will return 'a'. The alphabet 'a' is
shown as a checkbox in the Marlett Font and hence you would see a
checkbox. If A1 is less than 0, the formula returns a blank and it would
appear as a blank in Marlett Font also.

Regards

Govind.C. Cunningham wrote:

gt; Is it possible to have the checkbox value (either checked or unchecked)
gt; dependent on if the number in another cell is positive or negative (greater
gt; than or less than zero)?
gt;
gt; I've tried the quot;cell linkquot; option on the quot;controlquot; tab of the format control
gt; popup menu, but it doesn't return what I want. It seems to do the opposite.
gt; It takes the value of the checkbox and returns a true or false in the linked
gt; cell. Is there a way to reverse it?
gt;
gt; I'm using this on an expense voucher form and the checkbox indicates if the
gt; final balance due (after deducting any advanced monies) is payable to the
gt; company (negative balance) or payable to the employee (positive balance).
gt;
gt; Any help is appreciated. Using Excel 2002 with Windows XP Professional.

Hi,

Thanks for the workaround, but the forms will be placed on the company wide
intranet, and not everyone who will access the form will have the same fonts.
Also, I need there to be a blank checkbox if a checked box does not apply.

Does anyone else have any suggestions?
quot;Govindquot; wrote:

gt; Hi,
gt;
gt; Am not sure if this is possible with Checkbox created using Forms
gt; toolbar, but i have got a workaround.
gt;
gt; Enter the following simple formula in the cell (Say B1) , where you want
gt; the Checkbox :
gt;
gt; =IF(A1gt;0,quot;aquot;,quot;quot;) where A1 is the cell which has got the positive or
gt; negative number.
gt;
gt; And then format the cell B1 to the Font called 'Marlett'.
gt;
gt; Now, when A1 is more than 0, B1 will return 'a'. The alphabet 'a' is
gt; shown as a checkbox in the Marlett Font and hence you would see a
gt; checkbox. If A1 is less than 0, the formula returns a blank and it would
gt; appear as a blank in Marlett Font also.
gt;
gt; Regards
gt;
gt; Govind.
gt;
gt;
gt; C. Cunningham wrote:
gt;
gt; gt; Is it possible to have the checkbox value (either checked or unchecked)
gt; gt; dependent on if the number in another cell is positive or negative (greater
gt; gt; than or less than zero)?
gt; gt;
gt; gt; I've tried the quot;cell linkquot; option on the quot;controlquot; tab of the format control
gt; gt; popup menu, but it doesn't return what I want. It seems to do the opposite.
gt; gt; It takes the value of the checkbox and returns a true or false in the linked
gt; gt; cell. Is there a way to reverse it?
gt; gt;
gt; gt; I'm using this on an expense voucher form and the checkbox indicates if the
gt; gt; final balance due (after deducting any advanced monies) is payable to the
gt; gt; company (negative balance) or payable to the employee (positive balance).
gt; gt;
gt; gt; Any help is appreciated. Using Excel 2002 with Windows XP Professional.
gt;

Thanks Govind, I was actually able to use your formula in different way, but
now it returns exactly what I want it to do.

I did a little bit more reseach on the web on the cell link option, and
found the following tips website:
exceltips.vitalnews.com/Pages...eck_Boxes.html

In this page it talks about the fact that quot;When the check box changes, the
contents of this cell change; when the contents of the cell are changed, the
check box reflects that change--it is a bi-directional relationship.quot;

So, first I linked the check box to the cell underneath it. Then I went
into that cell and entered the formula =IF(L31gt;0,TRUE,FALSE). For the other
checkbox, I just reversed the lt; sign in the formula. Then depending on
whether the formula in L31 returns a negative or positive, the checkboxes
behave accordingly. Lastly, I went in and changed the text color of my
linked cells to white, so that the formula would be hidden, and then I locked
the cells.

Thanks for pointing me in the right direction!

quot;C. Cunninghamquot; wrote:

gt; Hi,
gt;
gt; Thanks for the workaround, but the forms will be placed on the company wide
gt; intranet, and not everyone who will access the form will have the same fonts.
gt; Also, I need there to be a blank checkbox if a checked box does not apply.
gt;
gt; Does anyone else have any suggestions?
gt;
gt;
gt;
gt; quot;Govindquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; Am not sure if this is possible with Checkbox created using Forms
gt; gt; toolbar, but i have got a workaround.
gt; gt;
gt; gt; Enter the following simple formula in the cell (Say B1) , where you want
gt; gt; the Checkbox :
gt; gt;
gt; gt; =IF(A1gt;0,quot;aquot;,quot;quot;) where A1 is the cell which has got the positive or
gt; gt; negative number.
gt; gt;
gt; gt; And then format the cell B1 to the Font called 'Marlett'.
gt; gt;
gt; gt; Now, when A1 is more than 0, B1 will return 'a'. The alphabet 'a' is
gt; gt; shown as a checkbox in the Marlett Font and hence you would see a
gt; gt; checkbox. If A1 is less than 0, the formula returns a blank and it would
gt; gt; appear as a blank in Marlett Font also.
gt; gt;
gt; gt; Regards
gt; gt;
gt; gt; Govind.
gt; gt;
gt; gt;
gt; gt; C. Cunningham wrote:
gt; gt;
gt; gt; gt; Is it possible to have the checkbox value (either checked or unchecked)
gt; gt; gt; dependent on if the number in another cell is positive or negative (greater
gt; gt; gt; than or less than zero)?
gt; gt; gt;
gt; gt; gt; I've tried the quot;cell linkquot; option on the quot;controlquot; tab of the format control
gt; gt; gt; popup menu, but it doesn't return what I want. It seems to do the opposite.
gt; gt; gt; It takes the value of the checkbox and returns a true or false in the linked
gt; gt; gt; cell. Is there a way to reverse it?
gt; gt; gt;
gt; gt; gt; I'm using this on an expense voucher form and the checkbox indicates if the
gt; gt; gt; final balance due (after deducting any advanced monies) is payable to the
gt; gt; gt; company (negative balance) or payable to the employee (positive balance).
gt; gt; gt;
gt; gt; gt; Any help is appreciated. Using Excel 2002 with Windows XP Professional.
gt; gt;

Hi,

Great to know of that. I wasnt aware of the bi-directional relationship
between Cell link and the checkbox. Thanks for letting me know on that.

Regards

Govind.

C. Cunningham wrote:
gt; Thanks Govind, I was actually able to use your formula in different way, but
gt; now it returns exactly what I want it to do.
gt;
gt; I did a little bit more reseach on the web on the cell link option, and
gt; found the following tips website:
gt; exceltips.vitalnews.com/Pages...eck_Boxes.html
gt;
gt; In this page it talks about the fact that quot;When the check box changes, the
gt; contents of this cell change; when the contents of the cell are changed, the
gt; check box reflects that change--it is a bi-directional relationship.quot;
gt;
gt; So, first I linked the check box to the cell underneath it. Then I went
gt; into that cell and entered the formula =IF(L31gt;0,TRUE,FALSE). For the other
gt; checkbox, I just reversed the lt; sign in the formula. Then depending on
gt; whether the formula in L31 returns a negative or positive, the checkboxes
gt; behave accordingly. Lastly, I went in and changed the text color of my
gt; linked cells to white, so that the formula would be hidden, and then I locked
gt; the cells.
gt;
gt; Thanks for pointing me in the right direction!
gt;
gt; quot;C. Cunninghamquot; wrote:
gt;
gt;
gt;gt;Hi,
gt;gt;
gt;gt;Thanks for the workaround, but the forms will be placed on the company wide
gt;gt;intranet, and not everyone who will access the form will have the same fonts.
gt;gt; Also, I need there to be a blank checkbox if a checked box does not apply.
gt;gt;
gt;gt;Does anyone else have any suggestions?
gt;gt;
gt;gt;
gt;gt;
gt;gt;quot;Govindquot; wrote:
gt;gt;
gt;gt;
gt;gt;gt;Hi,
gt;gt;gt;
gt;gt;gt;Am not sure if this is possible with Checkbox created using Forms
gt;gt;gt;toolbar, but i have got a workaround.
gt;gt;gt;
gt;gt;gt;Enter the following simple formula in the cell (Say B1) , where you want
gt;gt;gt;the Checkbox :
gt;gt;gt;
gt;gt;gt;=IF(A1gt;0,quot;aquot;,quot;quot;) where A1 is the cell which has got the positive or
gt;gt;gt;negative number.
gt;gt;gt;
gt;gt;gt;And then format the cell B1 to the Font called 'Marlett'.
gt;gt;gt;
gt;gt;gt;Now, when A1 is more than 0, B1 will return 'a'. The alphabet 'a' is
gt;gt;gt;shown as a checkbox in the Marlett Font and hence you would see a
gt;gt;gt;checkbox. If A1 is less than 0, the formula returns a blank and it would
gt;gt;gt;appear as a blank in Marlett Font also.
gt;gt;gt;
gt;gt;gt;Regards
gt;gt;gt;
gt;gt;gt;Govind.
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;C. Cunningham wrote:
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;gt;Is it possible to have the checkbox value (either checked or unchecked)
gt;gt;gt;gt;dependent on if the number in another cell is positive or negative (greater
gt;gt;gt;gt;than or less than zero)?
gt;gt;gt;gt;
gt;gt;gt;gt;I've tried the quot;cell linkquot; option on the quot;controlquot; tab of the format control
gt;gt;gt;gt;popup menu, but it doesn't return what I want. It seems to do the opposite.
gt;gt;gt;gt;It takes the value of the checkbox and returns a true or false in the linked
gt;gt;gt;gt;cell. Is there a way to reverse it?
gt;gt;gt;gt;
gt;gt;gt;gt;I'm using this on an expense voucher form and the checkbox indicates if the
gt;gt;gt;gt;final balance due (after deducting any advanced monies) is payable to the
gt;gt;gt;gt;company (negative balance) or payable to the employee (positive balance).
gt;gt;gt;gt;
gt;gt;gt;gt;Any help is appreciated. Using Excel 2002 with Windows XP Professional.
gt;gt;gt;