Typing in a text box control

[hmm]

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?

[Carim]

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

[hmm]

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