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: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=531294

Carim,

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 -- 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?

"Carim" wrote:


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: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=531294