software

When I create a text box control on a spreadsheet (Excel 2000), the only way
to type text in it is to right click and select Edit. Is there any way to
make it so that when I move the mouse pointer over the text box, it will turn
into a text entry cursor?


Edit your TextBox , select Properties , go to Linkcell and type A1 and
close all
Now whatever is typed in cell A1 will appear automatically in TextBox

HTH
Carim--
Carim
------------------------------------------------------------------------
Carim's Profile: www.excelforum.com/member.php...oamp;userid=33259
View this thread: www.excelforum.com/showthread...hreadid=531294Carim,

By linking, I know I can type in A1--then whatever I type will appear in the
text box. My question is the other way around: I want to type in the text
box, then whatever I type will appear in A1.

The problem I have is that when I move the cursor over the text box, I do
not get the familiar text-insertion cursor that would allow me to click and
type. Instead, I have to right-click and select TextBox Object --gt; Edit,
then I can type.

Can I get the mouse pointer over the text box control to be that sort of
click-and-type cursor?

quot;Carimquot; wrote:

gt;
gt; Edit your TextBox , select Properties , go to Linkcell and type A1 and
gt; close all
gt; Now whatever is typed in cell A1 will appear automatically in TextBox
gt;
gt; HTH
gt; Carim
gt;
gt;
gt; --
gt; Carim
gt; ------------------------------------------------------------------------
gt; Carim's Profile: www.excelforum.com/member.php...oamp;userid=33259
gt; View this thread: www.excelforum.com/showthread...hreadid=531294
gt;
gt;