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)


"gibbylinks" wrote in message
...
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

Thanks

Got it working.

Paul

"Bob Phillips" wrote:

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)


"gibbylinks" wrote in message
...
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

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

"gibbylinks" wrote:

Thanks

Got it working.

Paul

"Bob Phillips" wrote:

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)


"gibbylinks" wrote in message
...
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

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



"gibbylinks" wrote:

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

"gibbylinks" wrote:

Thanks

Got it working.

Paul

"Bob Phillips" wrote:

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)


"gibbylinks" wrote in message
...
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