Linking a textbox to a cell in another workbk

[amelia]

I would like to link a textbox in workbk A to a cell in workbk B. So far, I
couldn't find any direct hyperlink to do the above. Appreciate any
suggestions. Thanks!

 

[Gary''s Student]

Where you click is EXTREMELY important.

Put a Textbox on a worksheet (I used the drawing toolbar). Click in the
Textbox (as though you were going to type some text).

Then click in the Formula Bar instead, and in the Formula Bar type something
like:

=[Book3.xls]Sheet1!$C$4

The value of the target cell in Book3 will appear in the Textbox.

If you tried to type the formula directly in the Textbox, all you would get
is a string.

 

[amelia]

Where you click is EXTREMELY important.

Put a Textbox on a worksheet (I used the drawing toolbar). Click in the
Textbox (as though you were going to type some text).

Then click in the Formula Bar instead, and in the Formula Bar type something
like:

=[Book3.xls]Sheet1!$C$4

The value of the target cell in Book3 will appear in the Textbox.

If you tried to type the formula directly in the Textbox, all you would get
is a string.
--
Gary''s Student - gsnu200843

I would like to link a textbox in workbk A to a cell in workbk B. So far, I
couldn't find any direct hyperlink to do the above. Appreciate any
suggestions. Thanks!

Thanks Gary..but mayb i should explain the question again.

I have 2 workbks. What i want is that when a user clicks the word "Go" which
is in a textbox in workbk A, it will be hyperlinked to cell A1 in workbk B.

 

[Gary''s Student]

O.K.

After clicking in the Textbox, move the cursor to the very edge of the
Textbox. The cursor will become a slim plus with 4 arrows. Then right-click
and pick Hyperlink...

This is the bottom option.

Enter something like:

file:///c:\test\beta.xls

as the target. Now clicking on the Textbox will activate the hyperlink and
take you to beta.xls


By the way, you can do something similar with any piece of ClipArt, not just
a Textbox.
--
Gary''s Student - gsnu200843

Where you click is EXTREMELY important.

Put a Textbox on a worksheet (I used the drawing toolbar). Click in the
Textbox (as though you were going to type some text).

Then click in the Formula Bar instead, and in the Formula Bar type something
like:

=[Book3.xls]Sheet1!$C$4

The value of the target cell in Book3 will appear in the Textbox.

If you tried to type the formula directly in the Textbox, all you would get
is a string.
--
Gary''s Student - gsnu200843

I would like to link a textbox in workbk A to a cell in workbk B. So far, I
couldn't find any direct hyperlink to do the above. Appreciate any
suggestions. Thanks!

Thanks Gary..but mayb i should explain the question again.

I have 2 workbks. What i want is that when a user clicks the word "Go" which
is in a textbox in workbk A, it will be hyperlinked to cell A1 in workbk B.

 

[amelia]

That works..but i would like to hyperlink to a specific sheet in beta.xlsm. I
tried entering the below..

file:///c:\test\beta.xlsm - 'Sheet1'!A1

but I got a pop up message: "Cannot open specified file"

Thanks again.

O.K.

After clicking in the Textbox, move the cursor to the very edge of the
Textbox. The cursor will become a slim plus with 4 arrows. Then right-click
and pick Hyperlink...

This is the bottom option.

Enter something like:

file:///c:\test\beta.xls

as the target. Now clicking on the Textbox will activate the hyperlink and
take you to beta.xls


By the way, you can do something similar with any piece of ClipArt, not just
a Textbox.
--
Gary''s Student - gsnu200843

Where you click is EXTREMELY important.

Put a Textbox on a worksheet (I used the drawing toolbar). Click in the
Textbox (as though you were going to type some text).

Then click in the Formula Bar instead, and in the Formula Bar type something
like:

=[Book3.xls]Sheet1!$C$4

The value of the target cell in Book3 will appear in the Textbox.

If you tried to type the formula directly in the Textbox, all you would get
is a string.
--
Gary''s Student - gsnu200843


:

I would like to link a textbox in workbk A to a cell in workbk B. So far, I
couldn't find any direct hyperlink to do the above. Appreciate any
suggestions. Thanks!

Thanks Gary..but mayb i should explain the question again.

I have 2 workbks. What i want is that when a user clicks the word "Go" which
is in a textbox in workbk A, it will be hyperlinked to cell A1 in workbk B.