Auto enter text if tick box checked

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

Guest

Is it possible to put text in a cell, if a check box is ticked somewhere else
on the spreadsheet ? but leave it blank if nothing is ticked.

Cheers

Paul
 
Check boxes are linked to another cell (you specified this when you set
up the check box). So if "Checkbox1" is linked to cell A10, cell A10
will show TRUE when Checkbox1 is ticked and FALSE when it is unchecked.
In any other cell you could then write an IF statement along the lines
of
=IF(A10=TRUE,"Your text here","")
 
If you use a tick in a cell, it is easy. Assume that the cell is A1, to get
a tick, form at as Marlett, and enter a. Then in another cell
=IF(A1="a","some text","")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thanks

Got it working.

Paul

Bob Phillips said:
If you use a tick in a cell, it is easy. Assume that the cell is A1, to get
a tick, form at as Marlett, and enter a. Then in another cell
=IF(A1="a","some text","")

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
Help Panic...... All went well until we tried to protect the cells. Then it
doesn't work, is there a way around this ??

Using Exel 2000
 
Sorted it, we had locked the cell that held the TRUE/FALSE value. Unlocking
that and hiding it has solved it.
 
Back
Top