Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting multiple text boxes
Hi Stuart,
Try: Sub Tester() Dim objShape As Shape For Each objShape In ActiveSheet.Shapes If objShape.Name Like ("myBox*") Then objShape.Select (False) '<<== Note use of False End If Next objShape End Sub PS: Seeing the time of your question, this is JIT, and more! --- Regards, Norman "Stuart" wrote in message ... How do I select all the text boxes on a worksheet begining with the same name, the following selects them in turn, however I wish to select all of them at once? Presumably I need to build an Array of all the differant names, but how do I do that through VBA For Each objShape In ActiveSheet.Shapes If objShape.Name Like ("myBox*") Then objShape.Select End If Next objShape |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting multiple text boxes
How do I select all the text boxes on a worksheet begining with the same
name, the following selects them in turn, however I wish to select all of them at once? Presumably I need to build an Array of all the differant names, but how do I do that through VBA For Each objShape In ActiveSheet.Shapes If objShape.Name Like ("myBox*") Then objShape.Select End If Next objShape |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting multiple text boxes
Many thanks, works just how I want it to!
What is the PS thing .... JIT ??????? ..... don't get it "Norman Jones" wrote in message ... Hi Stuart, Try: Sub Tester() Dim objShape As Shape For Each objShape In ActiveSheet.Shapes If objShape.Name Like ("myBox*") Then objShape.Select (False) '<<== Note use of False End If Next objShape End Sub PS: Seeing the time of your question, this is JIT, and more! --- Regards, Norman "Stuart" wrote in message ... How do I select all the text boxes on a worksheet begining with the same name, the following selects them in turn, however I wish to select all of them at once? Presumably I need to build an Array of all the differant names, but how do I do that through VBA For Each objShape In ActiveSheet.Shapes If objShape.Name Like ("myBox*") Then objShape.Select End If Next objShape |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting multiple text boxes
Hi Stuart,
JIT === 'Just In Time', asytem designed to respond as, and when, needed. From the post times, it would appear that I responded even before you posted the question! --- Regards, Norman "Stuart" wrote in message ... Many thanks, works just how I want it to! What is the PS thing .... JIT ??????? ..... don't get it "Norman Jones" wrote in message ... Hi Stuart, Try: Sub Tester() Dim objShape As Shape For Each objShape In ActiveSheet.Shapes If objShape.Name Like ("myBox*") Then objShape.Select (False) '<<== Note use of False End If Next objShape End Sub PS: Seeing the time of your question, this is JIT, and more! --- Regards, Norman "Stuart" wrote in message ... How do I select all the text boxes on a worksheet begining with the same name, the following selects them in turn, however I wish to select all of them at once? Presumably I need to build an Array of all the differant names, but how do I do that through VBA For Each objShape In ActiveSheet.Shapes If objShape.Name Like ("myBox*") Then objShape.Select End If Next objShape |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to select multiple text boxes in excel for formatting | New Users to Excel | |||
Excel spreadsheet is corrupted with multiple text boxes? | Excel Discussion (Misc queries) | |||
HOW TO DELETE MULTIPLE TEXT BOXES FROM A TEMPLATE FILE | Excel Discussion (Misc queries) | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Multiple text boxes selection | Excel Worksheet Functions |