Posted to microsoft.public.excel.programming

Dr. Schwartz[_2_] Dr. Schwartz[_2_] is offline

external usenet poster

Posts: 30

Deleting a textbox

I want to delete any (all) textboxes in the activesheet. This is what I have
got so far:

For Each Shapes.TextBox In ActiveSheet
.Delete
Next

Can anyone help me make this work?
Thanks
The Doctor

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting value in TextBox with SpinButton attached	markb	Excel Programming	8	March 3rd 07 10:45 PM
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys	Minitman[_4_]	Excel Programming	0	February 22nd 05 08:50 PM
Textbox Bug? Missing/delayed update of textbox filled via VBA	MarcM	Excel Programming	0	November 4th 04 05:43 PM
Deleting a textbox control at runtime	Grant Williams	Excel Programming	3	June 14th 04 08:33 AM

All times are GMT +1. The time now is 01:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us