Excel Help, check boxes

[MBigD011]

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