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

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.


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=548636

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

Hi Jose

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

--
Regards

Roger Govier


"Jose Zarate" <Jose (E-Mail Removed)> wrote in message
news:6D39D5A6-9600-4D7B-8387-(E-Mail Removed)...
> 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

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


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=548636

Thanks for the help.



"MartinShort" wrote:

>
> 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
>
>
> --
> MartinShort
>
> Software Tester
> ------------------------------------------------------------------------
> MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
> View this thread: http://www.excelforum.com/showthread...hreadid=548636
>
>