VBA for searching the max value

[pezalmendra]

Hi!

Im looking for a VBA code so that each time I initialize my userform, appears in TextBox1 the maximum value from the Range(A9:till the last value entered) located in Sheet3

Thanks for the help!

Regardss

[mikerickson]

Try

Please Login or Register  to view this content.

[pezalmendra]

Hello!

I didnt manage to make it work...
I think I better attach the file, that would make it easier.

What Im looking for is:

In UserForm "STOPS" ---> TextBox "T1"

I would like to display here the MAX Value +1 of the data stored in Range(A9:till the end from Sheet Trips Overview
And if there is no data in that Range then make T1 = "N/A"

Any help would be much appreciated. Thank you!

Regards

[mikerickson]

What do you mean doesn't work?

Try

Please Login or Register  to view this content.

[pezalmendra]

Hi mikerickson,

First of all thanks for your help and attention.
I inserted the code but it always returns the value "0" (N/A in this case).

In Range(A9:A65536) the max value is 3 in this situation and doesnt return that value...

Regards

[mikerickson]

The data is column A is formatted as text, which always plays havoc with a worksheet.
Try

Please Login or Register  to view this content.

[pezalmendra]

mikerickson!!

Thanks man! Running great and as I wanted!

[mikerickson]

You should probably track down where that number as text formatting came from and try to eliminate it.
Column A may not be the only problem created by that.