Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES
How can I create an "IF" statament that will choose the choice a check box
has made (ie: good, fair, poor) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES
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 "pjb" wrote in message ... How can I create an "IF" statament that will choose the choice a check box has made (ie: good, fair, poor) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES
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 "Biff" wrote: 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 "pjb" wrote in message ... How can I create an "IF" statament that will choose the choice a check box has made (ie: good, fair, poor) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES
"pjb" wrote:
.. If doing it with option buttons, 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 http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES
Where's the other post?
I guess I'll just delete my sample file! <g Biff "Max" wrote in message ... "pjb" wrote: .. If doing it with option buttons, 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 http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES
Where's the other post?
Ok, found it. Only 4 posts away! Biff "Biff" wrote in message ... Where's the other post? I guess I'll just delete my sample file! <g Biff "Max" wrote in message ... "pjb" wrote: .. If doing it with option buttons, 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 http://savefile.com/projects/236895 xdemechanik --- |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying
How can I copy the contents of a cell (the result of a formula) to another
worksheet without copying the formula. thanks. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying
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." "pjb" wrote in message ... How can I copy the contents of a cell (the result of a formula) to another worksheet without copying the formula. thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to add up check boxes | Excel Discussion (Misc queries) | |||
how do you add up check boxes | Excel Discussion (Misc queries) | |||
Filtering by Check Boxes | Excel Discussion (Misc queries) | |||
Check Boxes & Data Validation | Excel Discussion (Misc queries) | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) |