Posted to microsoft.public.excel.programming

john tempest[_2_] john tempest[_2_] is offline

external usenet poster

Posts: 27

delete from text box using command button

i am trying to write some code to clear a text box .the text box is from the
drawing toolbar. i have trid the following but to no avail:
Private Sub CommandButton3_Click()
With Sheet2.Shapes("Text Box 1").TextFrame
..Characters(.Characters.Count + 1).ClearContents
End With
End Sub
any suggestions
regards john

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
Delete command button ?	SpookiePower	Excel Programming	3	January 23rd 06 02:46 PM
Delete a command button via VBA	Brian K. Sheperd	Excel Programming	2	June 8th 05 03:57 PM
Delete with command button?	John[_100_]	Excel Programming	3	March 17th 05 01:38 PM
Delete command button	gavmer[_96_]	Excel Programming	0	October 19th 04 12:56 AM
Delete command button	BrianB	Excel Programming	0	October 18th 04 10:28 AM

All times are GMT +1. The time now is 06:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us