software

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

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
quot;checkedquot; at a time. With option buttons, only one can be selected at a
time.

Biff

quot;pjbquot; gt; wrote in message
...
gt; How can I create an quot;IFquot; statament that will choose the choice a check box
gt; has made (ie: good, fair, poor)
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

quot;Biffquot; wrote:

gt; Need more detail like:
gt;
gt; What kind of checkboxes are they? From the Forms toolbar or Control Toolbox?
gt;
gt; Do you have the checkboxes linked to cells?
gt;
gt; You may be better off using option buttons. More than one checkbox can be
gt; quot;checkedquot; at a time. With option buttons, only one can be selected at a
gt; time.
gt;
gt; Biff
gt;
gt; quot;pjbquot; gt; wrote in message
gt; ...
gt; gt; How can I create an quot;IFquot; statament that will choose the choice a check box
gt; gt; has made (ie: good, fair, poor)
gt;
gt;
gt;

quot;pjbquot; wrote:
gt; .. If doing it with option buttons,
gt; how would I create that statement,

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
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Where's the other post?

I guess I'll just delete my sample file! lt;ggt;

Biff

quot;Maxquot; gt; wrote in message
...
gt; quot;pjbquot; wrote:
gt;gt; .. If doing it with option buttons,
gt;gt; how would I create that statement,
gt;
gt; See your other post, where I've given a play on setting up and grouping 4
gt; option buttons, and a way to extract the selection made amongst the 4
gt; option
gt; buttons in another sheet via a VLOOKUP
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt;
gt;
gt;Where's the other post?

Ok, found it. Only 4 posts away!

Biff

quot;Biffquot; gt; wrote in message
...
gt; Where's the other post?
gt;
gt; I guess I'll just delete my sample file! lt;ggt;
gt;
gt; Biff
gt;
gt; quot;Maxquot; gt; wrote in message
gt; ...
gt;gt; quot;pjbquot; wrote:
gt;gt;gt; .. If doing it with option buttons,
gt;gt;gt; how would I create that statement,
gt;gt;
gt;gt; See your other post, where I've given a play on setting up and grouping 4
gt;gt; option buttons, and a way to extract the selection made amongst the 4
gt;gt; option
gt;gt; buttons in another sheet via a VLOOKUP
gt;gt; --
gt;gt; Max
gt;gt; Singapore
gt;gt; savefile.com/projects/236895
gt;gt; xdemechanik
gt;gt; ---
gt;gt;
gt;gt;
gt;
gt;
How can I copy the contents of a cell (the result of a formula) to another
worksheet without copying the formula. thanks.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 quot;values.quot;

quot;pjbquot; gt; wrote in message
...
gt; How can I copy the contents of a cell (the result of a formula) to another
gt; worksheet without copying the formula. thanks.
gt;