How to determine the end of a textbox array ?

Well i have a grid(array) of textboxes that expands or contracts accordingly to the data fed into it. Its in the form text.text(i) . Is there a way to determine the last textbox in the array, like EOF idea ?

if text.text(i) = EOF(last textbox in grid) then,

kind of thing.

I think you're after the Ubound property of the textbox array:

VB Code:

If i = TextBoxArray.Ubound Then 'last textbox

-adehh

Think this will work

VB Code:

For x = 0 To Text1.UBound
    blah blah
Next x

Quote:

---

Originally posted by adzzzz
I think you're after the Ubound property of the textbox array:

VB Code:

If i = TextBoxArray.Ubound Then 'last textbox

-adehh

---

or

VB Code:

If i = TextBoxArray.Count - 1 Then

take your pick