CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES

P

pjb

How can I create an "IF" statament that will choose the choice a check box
has made (ie: good, fair, poor)
 
B

Biff

Need more detail like:

What kind of checkboxes are they? From the Forms toolbar or Control Toolbox?

Do you have the checkboxes linked to cells?

You may be better off using option buttons. More than one checkbox can be
"checked" at a time. With option buttons, only one can be selected at a
time.

Biff
 
P

pjb

They are checkboxes from the forms toolbar and they are linked to specific
cells. If doing it with option buttons, how would I create that statement,
thanks
 
M

Max

pjb said:
.. If doing it with option buttons,
how would I create that statement,
Click to expand...

See your other post, where I've given a play on setting up and grouping 4
option buttons, and a way to extract the selection made amongst the 4 option
buttons in another sheet via a VLOOKUP
 
P

pjb

How can I copy the contents of a cell (the result of a formula) to another
worksheet without copying the formula. thanks.
 
R

Richard O. Neville

Copy as usual from the originating cell. When you click on the receiving
cell, select Edit-Paste Special. The menu presents some choices of what to
copy; one of them is "values."
 
Top