Selecting an entire array

[Maerd]

Me again...

Well, I've accomplished somethign with your guys help. Now, I need to know who to select an entire array variable instead of having to do this:

Private Sub mnu_clear_Click()
Sector(0).Caption = ""
Sector(1).Caption = ""
Sector(2).Caption = ""
Sector(3).Caption = ""
Sector(4).Caption = ""
Sector(5).Caption = ""
Sector(6).Caption = ""
Sector(7).Caption = ""
Sector(8).Caption = ""
End Sub

How would I go about doing this? Please be kind and explain just a bit of it>

[RAEsquivelC]

This is the BASIC forum. Your posting is for VB or VBA. I believe you will get answers if you post in one of the available Visual Basic forums.

[RAEsquivelC]

For the eight array elements ou show, try:

Private Sub mnu_clear_Click()
For I = 1 to 9
Sector(I-1).Caption = ""
Next I
End Sub

And, let me know if this worked for you.