Simple Question: Select Text Box from Spreadsheet?

I am stuck on what seems a very simple problem: I can't select a textbox that is in a spreadsheet.

The textbox is called Text Box 125 (at least that's what appears in the top left corner, where it usually displays cell name like "J8").

I want to delete this textbox if a cell is empty. My difficulty is in selecting the box. I have tried things like:

TextBox125.Select

TxtBox125.Select

Text_Box_125.Select


What am I doing wrong?
Thanks!!

Excel ranges have a "select" method, Textboxes don't. You can, however
approach it other ways:
Me.TextBox125.Delete
or
ActiveSheet.Shapes("TextBox125").Delete

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Lost!" <[email protected]> wrote in message
news:[email protected]...
>
> I am stuck on what seems a very simple problem: I can't select a textbox
> that is in a spreadsheet.
>
> The textbox is called Text Box 125 (at least that's what appears in the
> top left corner, where it usually displays cell name like "J8").
>
> I want to delete this textbox if a cell is empty. My difficulty is in
> selecting the box. I have tried things like:
>
> TextBox125.Select
>
> TxtBox125.Select
>
> Text_Box_125.Select
>
>
> What am I doing wrong?
> Thanks!!
>
>
> --
> Lost!
> ------------------------------------------------------------------------
> Lost!'s Profile:
> http://www.excelforum.com/member.php...o&userid=23990
> View this thread: http://www.excelforum.com/showthread...hreadid=377116
>

You are asking about selecting the textbox, which is one thing, and deleting
it if a cell is empty. I'm not sure exactly what it is you want to do but
I'll do my best to describe how to do these things. To "select" the textbox
I presume you mean you don't want the cursor to go there to type in
something. You need to be in design mode.

On the menu bar do View-->Toolbars-->Control Toolbox. When the window opens
click on the button with the blue triangle and pencil. Now you can click on
the textbox to select it. Press the Delete key to permanently delete the
textbox.

If this is not what you want to do, maybe you mean you want to hide the
textbox (make it invisible) when a particular cell is empty. In the
Worksheet_Change sub you can do something like this:

TextBox125.Visible = Range("A1").Text <> ""


"Lost!" wrote:

>
> I am stuck on what seems a very simple problem: I can't select a textbox
> that is in a spreadsheet.
>
> The textbox is called Text Box 125 (at least that's what appears in the
> top left corner, where it usually displays cell name like "J8").
>
> I want to delete this textbox if a cell is empty. My difficulty is in
> selecting the box. I have tried things like:
>
> TextBox125.Select
>
> TxtBox125.Select
>
> Text_Box_125.Select
>
>
> What am I doing wrong?
> Thanks!!
>
>
> --
> Lost!
> ------------------------------------------------------------------------
> Lost!'s Profile: http://www.excelforum.com/member.php...o&userid=23990
> View this thread: http://www.excelforum.com/showthread...hreadid=377116
>
>

"Lost!" wrote:

> I was unclear. When I said I want to 'select' the box, I meant I want
> it to appear is if I had clicked on the border of the box and it was
> selected so that I could press the delete key and get rid of the box.

That's what I thought you meant. You need to be in Design Mode to select
the textbox as you mention. Then click on the textbox and press the delete
key. George's method should work too, but you may need to specify the sheet
by name like this:

Sheets("Sheet1").Shapes("TextBox125").Delete

But if you aren't creating and deleting controls on-the-fly, just going into
Design Mode to get rid of it is easiest. The only way I know to get into
Design Mode is through the View menu. View-->Toolbars-->Control Toolbox.
There should be a button with a blue triangle to toggle in and out of Design
Mode.