software

How can I create a link from one worksheet to another worksheet where I have
created check boxes to define the condition, being quot;goodquot; quot;fairquot; quot;poorquot; or
quot;badquot;
I think I need to use an quot;IFquot; statement.

quot;pjbquot; wrote:
gt; How can I create a link from one worksheet
gt; to another worksheet where I have
gt; created check boxes to define the condition,
gt; being quot;goodquot; quot;fairquot; quot;poorquot; or quot;badquot;
gt; I think I need to use an quot;IFquot; statement.

Yes, think you're on track with the IF statement lt;ggt;

Perhaps a simple tinker to grasp how it could be set-up ?

Assume in Sheet1,
we've drawn a forms checkbox 1 for say, quot;goodquot;

Right click on checkbox gt; Format Control
In the Control tab, put for Cell link: Sheet2!$I$1 (say)
Click OK

Then in Sheet2,
we could put in say, B1: =IF(I1,quot;goodquot;,quot;quot;)

The above will return quot;goodquot; in Sheet2's B1
if the checkbox 1 in Sheet1 is checked
(The cell link in Sheet2's I1 will show: TRUE)

And if it's unchecked, then Sheet2's B1 will return blank: quot;quot;
(The cell link in Sheet2's I1 will show: FALSE)

(Col I could be hidden away for neatness)

We could do likewise for the other checkboxes, viz.:
cell links in Sheet2's I2, I3, I4 ..,
and IF formulas in B2, B3, B4
reading the corresponding cell links
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Hi, your suggestion worked great, just add another little gliche, instead of
linking it different cells for different answers, when one of the four boxes
is checked can just the correct answer show in one linked cell. Thank you
very much.

quot;Maxquot; wrote:

gt; quot;pjbquot; wrote:
gt; gt; How can I create a link from one worksheet
gt; gt; to another worksheet where I have
gt; gt; created check boxes to define the condition,
gt; gt; being quot;goodquot; quot;fairquot; quot;poorquot; or quot;badquot;
gt; gt; I think I need to use an quot;IFquot; statement.
gt;
gt; Yes, think you're on track with the IF statement lt;ggt;
gt;
gt; Perhaps a simple tinker to grasp how it could be set-up ?
gt;
gt; Assume in Sheet1,
gt; we've drawn a forms checkbox 1 for say, quot;goodquot;
gt;
gt; Right click on checkbox gt; Format Control
gt; In the Control tab, put for Cell link: Sheet2!$I$1 (say)
gt; Click OK
gt;
gt; Then in Sheet2,
gt; we could put in say, B1: =IF(I1,quot;goodquot;,quot;quot;)
gt;
gt; The above will return quot;goodquot; in Sheet2's B1
gt; if the checkbox 1 in Sheet1 is checked
gt; (The cell link in Sheet2's I1 will show: TRUE)
gt;
gt; And if it's unchecked, then Sheet2's B1 will return blank: quot;quot;
gt; (The cell link in Sheet2's I1 will show: FALSE)
gt;
gt; (Col I could be hidden away for neatness)
gt;
gt; We could do likewise for the other checkboxes, viz.:
gt; cell links in Sheet2's I2, I3, I4 ..,
gt; and IF formulas in B2, B3, B4
gt; reading the corresponding cell links
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt;
gt;
gt;

quot;pjbquot; wrote
gt; .. instead of linking it different cells for different answers,
gt; when one of the four boxes is checked can
gt; just the correct answer show in one linked cell

Try using the forms option buttons instead
all housed within a forms Group Box

In Sheet1,
Draw a forms Group Box* on the sheet
(size it large enough for 4 option buttons)

*rectangle icon with the XYZ on top edge,
The group box ensures that only one option box
can be selected at any one time

Draw an option button for quot;goodquot; inside the group box
Set the cell link to point to say: Sheet2!$I$1

Copy the option button gt; paste to produce the 2nd option button for quot;fairquot;.
Move and space it vertically amp; close below the first button within the group
box. Repeat the copy gt; paste gt; position for the remaining 2 buttons quot;poorquot;,
then quot;badquot;

Then in Sheet2,
we could put in say, B1:
=VLOOKUP(I1,{1,quot;goodquot;;2,quot;fairquot;;3,quot;poorquot;;4,quot;badquot;},2 ,0)

B1 will return the option selected in Sheet1
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---