Auto enter text if tick box checked

[gibbylinks]

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

[Dave O]

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","")

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[gibbylinks]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>
>

[gibbylinks]

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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
> >
> >
> >

[gibbylinks]

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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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
> > > >
> > >
> > >
> > >