Check Box Issues

[Guest]

Hi,

I have a check box that switches between True/False. Is there a way I can
make it switch to numbers.

I want to be able to check the box on and have a number appear on a linked
box, and the box unchecked and have the number deleted.

Please help I'm out of Tylenol

 

[MartinShort]

The easiest way is to use an adjacent cell to the cell which contains
your True or False. So say the cell in question is A1, in B1 you would
type


Code:
--------------------
=IF(A1,1,"")
--------------------


The other alternative is to write a small amount of VBA code to achieve
the same thing directly - I wouldn't start coding unless you're
comfortable with the above though.

 

[Guest]

Hi Martin,

Thanks for the help. Now I'm getting somewere.

Is there a way to get rid of the True/False and just have the Number appear.
I have the check box in Cell A1, in Cell B1 I want the # to apear when the
box is checked.

Thanks,

Jose

 

[Roger Govier]

Hi Jose

With your True/False in A1
=--(A1) will return 1 or 0 so your linked cell formula could be
=B1*--(A1)

 

[MartinShort]

I'd hide the column if I were you. (Right Click Column Header and select
Hide)

If you are really desperate not to have it on that worksheet at all,
then put the linked cell (ie True/False column) on another worksheet,
link to this and then hide the worksheet.

Hope this helps

Martin

 

[Guest]

Thanks for the help.