How to determine the end of a textbox array ?

[Jmacp]

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.

[adzzzz]

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

If i = TextBoxArray.Ubound Then 'last textbox

-adehh

[BrianS]

Think this will work

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

[MartinLiss]

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

If i = TextBoxArray.Ubound Then 'last textbox

-adehh

or

If i = TextBoxArray.Count - 1 Then

take your pick