• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Excel Help, check boxes

M

MBigD011

n00b
Joined
Sep 10, 2005
Messages
54
I just learned how to create a check box so any help would be appreciated.

What I would like to do is change the output in the Linkedcell when the box is checked or not.

When you check the box the output in the LinkedCell is "TRUE" and "FALSE" when not checked. How/where can I change what the output is, for example I would like the linked box to say "West File" when checked. Also if I have multiple Check Boxes linked to the same cell how do I make the ouput blank for "false" (not checked).

I know how to do this in a round about way:Set my desired cell to read =IF(F106=TRUE,"West File","") Where F106 is a random cell that the check box is linked to, but that doesnt work for multiple check boxes (with only one possibly being checked) outputing onto one cell and it would be nice to eliminate the intermediate cell and just have the check box output value be custum.

Thanks



Thanks
 
You must log in or register to reply here.
Back
Top