| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking a textbox to a cell in another workbk
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking a textbox to a cell in another workbk
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 "amelia" wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking a textbox to a cell in another workbk
"Gary''s Student" wrote: 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 "amelia" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking a textbox to a cell in another workbk
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 "amelia" wrote: "Gary''s Student" wrote: 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 "amelia" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking a textbox to a cell in another workbk
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. "Gary''s Student" wrote: 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 "amelia" wrote: "Gary''s Student" wrote: 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 "amelia" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save the ind workshts in a workbk as separate workbks automatical | Excel Discussion (Misc queries) | |||
| How do I jump from the 1st worksht in a workbk 2 the very last | Excel Worksheet Functions | |||
| How get the same custom footer on all sheets of workbk w/o copy/pa | Excel Discussion (Misc queries) | |||
| How do I apply the same print settings to all sheets in a workbk | Excel Discussion (Misc queries) | |||
| Linking textbox and graphs | Excel Discussion (Misc queries) | |||
Linear Mode
