Hi!

Ok, I didn't fully understand what you wanted. I read this:

I want the printed message to print in only one cell

....to mean that no matter what checkbox was selected the message would
appear in the same cell.

If you have the checkboxes linked to column B then something like this will
work:

=IF(B1=TRUE,"your_message_here","")

Then you can just drag copy down the column.

Biff

"Russell-stanely" wrote in
message ...
Biff---thanks for your help. I am very close to what I want to
accomplish,
but I have a question about the formula example you gave me.

In your example, the cells are the same at the front of the formula and
the
end of the formula. (J1:K60) Shouldn't I plug in the NEXT set of cells
in
the second half of the formula so that the message is returned accoridng
to
the cell that is checked?

EX: I have check box 1 linked to cell b1 with the message in c1
I have check box 2 linked to cell b2, with the message in c2, and so on.

Should the formula read,
=IF(ISNA(VLOOKUP(TRUE, B1:C1,2,0)),"",VLOOKUP(TRUE, B2:C2,2,0)). Would
this return the message linked to checkbox 2 if checkbox 2 was the only
box
checked? I tried it this way, and I got a #N/A message.
Again, thanks for your help!!

"Biff" wrote:

Hi!

That's a lot of checkboxes on a form!

I do not know macros or vb

Well, neither do I so I'm assuming you used the Forms toolbar to create
the
checkboxes.

Here's an idea....

Link each checkbox to a cell. eg:

link ckbx1 to cell J1, ckbx2 to J2, ckbx3 to J3, ckbx4 to
J4............ckbx60 to J60.

Then in column K, K1:K60 list the message associated with each checkbox.

Formula to return the message depending on which checkbox is selected:

=IF(ISNA(VLOOKUP(TRUE,J1:K60,2,0)),"",VLOOKUP(TRUE ,J1:K60,2,0))

Biff

"Russell-stanely" wrote in
message ...
Hi. I am trying to desing a form where the user checks one box at the
top
of
the form and then at the bottom of the form there is a printed message
based
on what check box was checkced at the top. The form has about 60 check
boxes
at the top, and I want the printed message to print in only one cell,
based
on which check box was checked at the top. (I hope this is clear!) I
do
not know macros or vb and was hoping a formula (such as If(or) wouldr
work.\\\\\\\\\