keyword to clear array

[ADoozer]

arghh! someone posted a week ago or so a question about resetting all values in an array (other than the for i=lbound(array) to ubound(array) route)

it was a very simple keyword, but i cant remember it or find it...

can anyone point me to the thread or tell me the keyword!!!

thnx in advance! If somethings hard to do, its not worth doing - Homer Simpson

 

[DonQuichote]

It was "erase"

 

[LazyMe]

'Erase' is what you want....
Greetings,
Rick

 

[ADoozer]

cheers guys! If somethings hard to do, its not worth doing - Homer Simpson

 

[edderic]

??? Like

Private Sub Command1_Click()
Dim Contrl As Control
For Each Contrl In Form1.Controls
If (TypeOf Contrl Is TextBox) Then Contrl.Text = ""
Next Contrl
End Sub

Eric De Decker
vbg.be@vbgroup.nl

 

[ADoozer]

edderic: thanks for the input, the other guys got the nail on the head though, it really was that simple, just my brain died about 2.30 this afternoon.

appreciated anyways! If somethings hard to do, its not worth doing - Homer Simpson