| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting a textbox
For Each Shp In ActiveSheet.shapes
.Delete Next "Dr. Schwartz" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting a textbox
I left out a shp in my last posting
For Each Shp In ActiveSheet.Shapes Shp.Delete Next "Dr. Schwartz" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting a textbox
try this
Sub idtextbox() For Each sh In ActiveSheet.Shapes If sh.Type = 17 Then sh.Delete 'MsgBox sh.Name Next End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Dr. Schwartz" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting a textbox
Joel, I'm sure you meant well, but be aware that your suggestion here can
have serious consequenses. Please read the post: 'Validation list functionality disappered' for details. The doctor "Joel" wrote: I left out a shp in my last posting For Each Shp In ActiveSheet.Shapes Shp.Delete Next "Dr. Schwartz" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting value in TextBox with SpinButton attached | Excel Programming | |||
| HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
| Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
| Deleting a textbox control at runtime | Excel Programming | |||
![Dr. Schwartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
