how to check array is empty or not

[beeleegie]

I have an object array, and I want to clear up the object in the array when the form unload. The I use a for loop to loop the object array. Unfortunately, the object array sometimes won't initialize (empty inside), then it will call error when calling lbound(Array). Do anyone know how to check the array contains something or not, or have a better method to clear the objects in the array. Thank you very much.

 

[JohnYingling]

Dim intBound as Integer
On Error Resume next
intBound = Ubound(aryObj)
if Err.Number <> 0 then intBound = -1
On Error Goto 0
For I = 0 To intBound
.....
Next

But you could just
Erase aryObj ' assumming that it was defined
OR
Redim aryObj(0) ' no preserve

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript