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

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

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

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

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

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

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

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

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