CHECK BOX

[Guest]

HI All

I have a check box linked to cell I6 when checked it returns TRUE when unchecked it returns FALSE how can i change this to say YES instead of true and NO instead of FALSE

 

[Max]

Use an IF formula in another cell
to read the cell-link and return the desired outcome.

For example,

Put in J16: =IF(I16=TRUE,"YES","NO")

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
---

HI All,

I have a check box linked to cell I6 when checked it returns TRUE when

unchecked it returns FALSE how can i change this to say YES instead of true
and NO instead of FALSE

 

[Frank Kabel]

Hi
AFAIK you can't change the output of the linked cell (and you alson
can't change this format). But you may try to link a cell with code:
- disbale the liked cell in the properties dialog
- add the following code to your checkbox
Private Sub CheckBox1_Click()
If CheckBox1.Value Then
Range("A1").Value = "Yes"
Else
Range("A1").Value = "No"
End If
End Sub

 

[Peo Sjoblom]

Link to a cell out of sight (IV1 for example) then in I6 use this formula

=IF(IV1,"Yes","No")

the other option would be a macro but that is not necessary IMHO..

--

Regards,

Peo Sjoblom

HI All,

I have a check box linked to cell I6 when checked it returns TRUE when

unchecked it returns FALSE how can i change this to say YES instead of true
and NO instead of FALSE