If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking Text Box
I am putting together a workbook where the user would enter text information
in a text box since the Excel environment is not very conducive to text. I would like to carry the information the user types in into other worksheets within the same workbook. Does anyone know of a way that I can create a link that would enter the information the user typed in into other worksheet. I've been trying to use text boxes that link across worksheet to accomplish my goal but if you have a different way of capturing text that would allow for automatic entry in other worksheets I am open to suggestions. Thanks |
#2
|
|||
|
|||
Linking Text Box
Richard,
If you use the text box control (Control Toolbox, not Forms Toolbar), you can assign a linked cell property to any cell in any sheet. It's a two-way link. Or you can write code that executes when the text box has had an entry and do whatever you want in code. Double-click the text box control, and it'll take you there. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... I am putting together a workbook where the user would enter text information in a text box since the Excel environment is not very conducive to text. I would like to carry the information the user types in into other worksheets within the same workbook. Does anyone know of a way that I can create a link that would enter the information the user typed in into other worksheet. I've been trying to use text boxes that link across worksheet to accomplish my goal but if you have a different way of capturing text that would allow for automatic entry in other worksheets I am open to suggestions. Thanks |
#3
|
|||
|
|||
Linking Text Box
Hi Richard
as far as i know you can't "link" textboxes but you can reference a cell in a text box ... so if you have a sheet called - "Enter Text Here" and a bright yellow BIG cell (say A1) with the words - "Type your text here" then you can create text boxes on each of the other sheets with the formula ='Enter Text Here'!A1 (create the text box, click in the formula bar, link it to the cell just as you would any other cell). Hope this helps Cheers JulieD "Richard" wrote in message ... I am putting together a workbook where the user would enter text information in a text box since the Excel environment is not very conducive to text. I would like to carry the information the user types in into other worksheets within the same workbook. Does anyone know of a way that I can create a link that would enter the information the user typed in into other worksheet. I've been trying to use text boxes that link across worksheet to accomplish my goal but if you have a different way of capturing text that would allow for automatic entry in other worksheets I am open to suggestions. Thanks |
#4
|
|||
|
|||
Linking Text Box
Earl,
I am not familiar with VBA so that would be tough for me to do. However, I am not clear what you mean about using the text box control. Please clarify if you can. JulieD mentioned creating one giant cell and that will allow the link. If that's my only option, is there a way to give the user a little more flexibility with typing. For example, if you press enter it would normally kick you to the next cell unless you are using a text box. "Earl Kiosterud" wrote: Richard, If you use the text box control (Control Toolbox, not Forms Toolbar), you can assign a linked cell property to any cell in any sheet. It's a two-way link. Or you can write code that executes when the text box has had an entry and do whatever you want in code. Double-click the text box control, and it'll take you there. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... I am putting together a workbook where the user would enter text information in a text box since the Excel environment is not very conducive to text. I would like to carry the information the user types in into other worksheets within the same workbook. Does anyone know of a way that I can create a link that would enter the information the user typed in into other worksheet. I've been trying to use text boxes that link across worksheet to accomplish my goal but if you have a different way of capturing text that would allow for automatic entry in other worksheets I am open to suggestions. Thanks |
#5
|
|||
|
|||
Linking Text Box
JulieD,
I like your idea but I still worry that the user is going to have a hard time entering text especially if paragraphs or something similar is needed. Is there a way to get the cell to behave more like a Word document or even a text box and still be able to use your suggestion? Thanks for your help. -RA "JulieD" wrote: Hi Richard as far as i know you can't "link" textboxes but you can reference a cell in a text box ... so if you have a sheet called - "Enter Text Here" and a bright yellow BIG cell (say A1) with the words - "Type your text here" then you can create text boxes on each of the other sheets with the formula ='Enter Text Here'!A1 (create the text box, click in the formula bar, link it to the cell just as you would any other cell). Hope this helps Cheers JulieD "Richard" wrote in message ... I am putting together a workbook where the user would enter text information in a text box since the Excel environment is not very conducive to text. I would like to carry the information the user types in into other worksheets within the same workbook. Does anyone know of a way that I can create a link that would enter the information the user typed in into other worksheet. I've been trying to use text boxes that link across worksheet to accomplish my goal but if you have a different way of capturing text that would allow for automatic entry in other worksheets I am open to suggestions. Thanks |
#6
|
|||
|
|||
Linking Text Box
Richard,
Can you be a little more specific about what you want done. Use examples. I agree that Excel isn't normal from a user standpoint. I think you like that when you click into a text box, it puts a cursor there, with any existing stuff that's in it, like most computer screens. You can then change what's there, remove it, etc. In an worksheet cell Excel, the user selects the cell, but gets no cursor. And he needs to know that if he starts typing, he loses the original stuff (most users don't know about Excel's edit mode). And he doesn't see a cursor until he starts typing, but then the original stuff disappears. Quite unlike most computer screens. I won't go into using a text box from the Controls Toolbox until I have a better idea what you want to do. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... Earl, I am not familiar with VBA so that would be tough for me to do. However, I am not clear what you mean about using the text box control. Please clarify if you can. JulieD mentioned creating one giant cell and that will allow the link. If that's my only option, is there a way to give the user a little more flexibility with typing. For example, if you press enter it would normally kick you to the next cell unless you are using a text box. "Earl Kiosterud" wrote: Richard, If you use the text box control (Control Toolbox, not Forms Toolbar), you can assign a linked cell property to any cell in any sheet. It's a two-way link. Or you can write code that executes when the text box has had an entry and do whatever you want in code. Double-click the text box control, and it'll take you there. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... I am putting together a workbook where the user would enter text information in a text box since the Excel environment is not very conducive to text. I would like to carry the information the user types in into other worksheets within the same workbook. Does anyone know of a way that I can create a link that would enter the information the user typed in into other worksheet. I've been trying to use text boxes that link across worksheet to accomplish my goal but if you have a different way of capturing text that would allow for automatic entry in other worksheets I am open to suggestions. Thanks |
#7
|
|||
|
|||
Linking Text Box
Ok, here's what I am trying to do.
I am in the process of putting together a strategic planning template that will allow the user to input data from a variety of financial and operational sources. The structure of my template is to have one worksheet represent one business plan and then have one worksheet in the end that will summarize all the worksheets. The financial stuff is easy and links well into the summary because the data is entered into cells. The tough part is figuring out what to do with their written business goals. I would like them to be able to input their goals into a text box once and have that text box show up repeatedly at the top of each page (each worksheet is about 6 pgs long). I tried using text boxes because it would allow the user to enter data and be able to format as if a Word document. Cells are very hard to work with when entering text because for example you can't press "Enter" at the end of the sentence and start another paragraph because it will just kick you out to another cell. The text users will be entering are of a variety of lengths and formats so I thought the text box would accommodate the user's needs. The problem is that unless I can figure out a way to get the text to link somehow to other areas of the worksheet, the user will need to reenter the same information repeatedly at the top of the page. I know I can do a cell and link that across worksheet but then the user will have a difficult time formatting their information in Excel. I hope that explains the issue I am facing. Thanks "Earl Kiosterud" wrote: Richard, Can you be a little more specific about what you want done. Use examples. I agree that Excel isn't normal from a user standpoint. I think you like that when you click into a text box, it puts a cursor there, with any existing stuff that's in it, like most computer screens. You can then change what's there, remove it, etc. In an worksheet cell Excel, the user selects the cell, but gets no cursor. And he needs to know that if he starts typing, he loses the original stuff (most users don't know about Excel's edit mode). And he doesn't see a cursor until he starts typing, but then the original stuff disappears. Quite unlike most computer screens. I won't go into using a text box from the Controls Toolbox until I have a better idea what you want to do. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... Earl, I am not familiar with VBA so that would be tough for me to do. However, I am not clear what you mean about using the text box control. Please clarify if you can. JulieD mentioned creating one giant cell and that will allow the link. If that's my only option, is there a way to give the user a little more flexibility with typing. For example, if you press enter it would normally kick you to the next cell unless you are using a text box. "Earl Kiosterud" wrote: Richard, If you use the text box control (Control Toolbox, not Forms Toolbar), you can assign a linked cell property to any cell in any sheet. It's a two-way link. Or you can write code that executes when the text box has had an entry and do whatever you want in code. Double-click the text box control, and it'll take you there. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... I am putting together a workbook where the user would enter text information in a text box since the Excel environment is not very conducive to text. I would like to carry the information the user types in into other worksheets within the same workbook. Does anyone know of a way that I can create a link that would enter the information the user typed in into other worksheet. I've been trying to use text boxes that link across worksheet to accomplish my goal but if you have a different way of capturing text that would allow for automatic entry in other worksheets I am open to suggestions. Thanks |
#8
|
|||
|
|||
Linking Text Box
Richard,
First of all, I presume when you say "page" you mean printed page of a worksheet, and your worksheets require about 6 pages to print. Some people refer to the workbook as a worksheet, and the worksheets as pages. Just clarifying that point. There are a few possible ways to do this. To get stuff to appear in the top of every printed page, you could use "Rows to repeat at top" in File - Page setup - Sheet tab. It can be more than one row, if necessary. For the text box, use the Control Toolbox (View - Toolbars - Control Toolbox). Make a text box. With the Design Mode button (on Control Toolbox) lit, right-click your box and click "properties." In the resulting properies window, Linked cell box, type the address of the cell of the sheet into which you want textbox stuff to go. B2 'Sheet 2'!B2 (if a different sheet from the one containing the text box) Have this cell included in the Rows to repeat at top. Turn off Design Mode, and give it a try. Hope I didn't forget nothing. Another way is to have it put into the page heading, but this would require a macro. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... Ok, here's what I am trying to do. I am in the process of putting together a strategic planning template that will allow the user to input data from a variety of financial and operational sources. The structure of my template is to have one worksheet represent one business plan and then have one worksheet in the end that will summarize all the worksheets. The financial stuff is easy and links well into the summary because the data is entered into cells. The tough part is figuring out what to do with their written business goals. I would like them to be able to input their goals into a text box once and have that text box show up repeatedly at the top of each page (each worksheet is about 6 pgs long). I tried using text boxes because it would allow the user to enter data and be able to format as if a Word document. Cells are very hard to work with when entering text because for example you can't press "Enter" at the end of the sentence and start another paragraph because it will just kick you out to another cell. The text users will be entering are of a variety of lengths and formats so I thought the text box would accommodate the user's needs. The problem is that unless I can figure out a way to get the text to link somehow to other areas of the worksheet, the user will need to reenter the same information repeatedly at the top of the page. I know I can do a cell and link that across worksheet but then the user will have a difficult time formatting their information in Excel. I hope that explains the issue I am facing. Thanks "Earl Kiosterud" wrote: Richard, Can you be a little more specific about what you want done. Use examples. I agree that Excel isn't normal from a user standpoint. I think you like that when you click into a text box, it puts a cursor there, with any existing stuff that's in it, like most computer screens. You can then change what's there, remove it, etc. In an worksheet cell Excel, the user selects the cell, but gets no cursor. And he needs to know that if he starts typing, he loses the original stuff (most users don't know about Excel's edit mode). And he doesn't see a cursor until he starts typing, but then the original stuff disappears. Quite unlike most computer screens. I won't go into using a text box from the Controls Toolbox until I have a better idea what you want to do. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... Earl, I am not familiar with VBA so that would be tough for me to do. However, I am not clear what you mean about using the text box control. Please clarify if you can. JulieD mentioned creating one giant cell and that will allow the link. If that's my only option, is there a way to give the user a little more flexibility with typing. For example, if you press enter it would normally kick you to the next cell unless you are using a text box. "Earl Kiosterud" wrote: Richard, If you use the text box control (Control Toolbox, not Forms Toolbar), you can assign a linked cell property to any cell in any sheet. It's a two-way link. Or you can write code that executes when the text box has had an entry and do whatever you want in code. Double-click the text box control, and it'll take you there. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... I am putting together a workbook where the user would enter text information in a text box since the Excel environment is not very conducive to text. I would like to carry the information the user types in into other worksheets within the same workbook. Does anyone know of a way that I can create a link that would enter the information the user typed in into other worksheet. I've been trying to use text boxes that link across worksheet to accomplish my goal but if you have a different way of capturing text that would allow for automatic entry in other worksheets I am open to suggestions. Thanks |
#9
|
|||
|
|||
Linking Text Box
Richard,
By the way, Alt-Enter takes you to a new line within a cell. Not standard, though, admittedly. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... Ok, here's what I am trying to do. I am in the process of putting together a strategic planning template that will allow the user to input data from a variety of financial and operational sources. The structure of my template is to have one worksheet represent one business plan and then have one worksheet in the end that will summarize all the worksheets. The financial stuff is easy and links well into the summary because the data is entered into cells. The tough part is figuring out what to do with their written business goals. I would like them to be able to input their goals into a text box once and have that text box show up repeatedly at the top of each page (each worksheet is about 6 pgs long). I tried using text boxes because it would allow the user to enter data and be able to format as if a Word document. Cells are very hard to work with when entering text because for example you can't press "Enter" at the end of the sentence and start another paragraph because it will just kick you out to another cell. The text users will be entering are of a variety of lengths and formats so I thought the text box would accommodate the user's needs. The problem is that unless I can figure out a way to get the text to link somehow to other areas of the worksheet, the user will need to reenter the same information repeatedly at the top of the page. I know I can do a cell and link that across worksheet but then the user will have a difficult time formatting their information in Excel. I hope that explains the issue I am facing. Thanks "Earl Kiosterud" wrote: Richard, Can you be a little more specific about what you want done. Use examples. I agree that Excel isn't normal from a user standpoint. I think you like that when you click into a text box, it puts a cursor there, with any existing stuff that's in it, like most computer screens. You can then change what's there, remove it, etc. In an worksheet cell Excel, the user selects the cell, but gets no cursor. And he needs to know that if he starts typing, he loses the original stuff (most users don't know about Excel's edit mode). And he doesn't see a cursor until he starts typing, but then the original stuff disappears. Quite unlike most computer screens. I won't go into using a text box from the Controls Toolbox until I have a better idea what you want to do. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... Earl, I am not familiar with VBA so that would be tough for me to do. However, I am not clear what you mean about using the text box control. Please clarify if you can. JulieD mentioned creating one giant cell and that will allow the link. If that's my only option, is there a way to give the user a little more flexibility with typing. For example, if you press enter it would normally kick you to the next cell unless you are using a text box. "Earl Kiosterud" wrote: Richard, If you use the text box control (Control Toolbox, not Forms Toolbar), you can assign a linked cell property to any cell in any sheet. It's a two-way link. Or you can write code that executes when the text box has had an entry and do whatever you want in code. Double-click the text box control, and it'll take you there. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Richard" wrote in message ... I am putting together a workbook where the user would enter text information in a text box since the Excel environment is not very conducive to text. I would like to carry the information the user types in into other worksheets within the same workbook. Does anyone know of a way that I can create a link that would enter the information the user typed in into other worksheet. I've been trying to use text boxes that link across worksheet to accomplish my goal but if you have a different way of capturing text that would allow for automatic entry in other worksheets I am open to suggestions. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help on changing text size | Luke Sineath | Page Layout | 7 | June 11th, 2004 05:53 AM |
How do you insert a page break after a text box | Betty Sutton | Page Layout | 3 | June 9th, 2004 03:05 PM |
align text in middle of text box | Barbara White | Formatting Long Documents | 1 | May 19th, 2004 04:33 PM |
Text Box in table woes. :( | JOE | Tables | 10 | May 5th, 2004 01:21 AM |
Extracting text | Nemo | Worksheet Functions | 3 | April 6th, 2004 02:33 PM |