Is it possible to rename a text box? I'd like to change the name of the box
from the default Text Box # to something more meaningful

-Ryan

Make sure the formula bar is visible.

on the right side of the formula bar is the Name box.

select the text box and you should see the text box name in the name box.

Highlight it in the name box and type in your new name. Finish by hitting
the enter key.

Unselect and then reselect the text box. The name displayed should be the
new name. If not, repeat the above.

In code it is

Sub RenameBox()
Activesheet.Textboxes("Text Box 1").Name = "MyTextBox"
End Sub
--
Regards,
Tom Ogilvy

"Ryan" wrote:

Is it possible to rename a text box? I'd like to change the name of the box
from the default Text Box # to something more meaningful

-Ryan

Thanks Tom,

The problem was that I was in design mode and apparently you can't rename
Text boxes created using the autoshape toolbar while in design mode. Once I
exited design mode I was able to rename the text box. Now if you create a
text box from the control toolbar you must be in design mode to rename it.
Kind of confusing but now I think I got everything figured out.

-Ryan


"Tom Ogilvy" wrote:

Make sure the formula bar is visible.

on the right side of the formula bar is the Name box.

select the text box and you should see the text box name in the name box.

Highlight it in the name box and type in your new name. Finish by hitting
the enter key.

Unselect and then reselect the text box. The name displayed should be the
new name. If not, repeat the above.

In code it is

Sub RenameBox()
Activesheet.Textboxes("Text Box 1").Name = "MyTextBox"
End Sub
--
Regards,
Tom Ogilvy

"Ryan" wrote:

Is it possible to rename a text box? I'd like to change the name of the box
from the default Text Box # to something more meaningful

-Ryan

Scratch the previous response. The problem was that I was not clicking on the
frame of the text box. I was just clicking the the text inside the box which
did not let me rename the text box. When I just click the frame I AM able to
rename the box. Design mode had nothing to do with it.

-Ryan

"Ryan" wrote:

Thanks Tom,

The problem was that I was in design mode and apparently you can't rename
Text boxes created using the autoshape toolbar while in design mode. Once I
exited design mode I was able to rename the text box. Now if you create a
text box from the control toolbar you must be in design mode to rename it.
Kind of confusing but now I think I got everything figured out.

-Ryan


"Tom Ogilvy" wrote:

Make sure the formula bar is visible.

on the right side of the formula bar is the Name box.

select the text box and you should see the text box name in the name box.

Highlight it in the name box and type in your new name. Finish by hitting
the enter key.

Unselect and then reselect the text box. The name displayed should be the
new name. If not, repeat the above.

In code it is

Sub RenameBox()
Activesheet.Textboxes("Text Box 1").Name = "MyTextBox"
End Sub
--
Regards,
Tom Ogilvy

"Ryan" wrote:

Is it possible to rename a text box? I'd like to change the name of the box
from the default Text Box # to something more meaningful

-Ryan