CHECK BOX

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
---
JInx said:
HI All,

I have a check box linked to cell I6 when checked it returns TRUE when
Click to expand...
unchecked it returns FALSE how can i change this to say YES instead of true
and NO instead of FALSE
 
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
 
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


JInx said:
HI All,

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