vba excel - test userform entry greater than last entry

I've searched around, but not much luck. Assume a userform with a numeric text control entry and submit button. I've been struggling with requiring vba to evaluate the previous user sheet entry to the current user control entry. I'm looking for something akin to:

Please Login or Register  to view this content.

Basically the text control value cannot be smaller than the last cell data in range C.

.
Try this (use in your UserForm) :

Please Login or Register  to view this content.

I think this is really close. It works up until exactly 10000. Something is going on with the code when anything over 10000 is entered. I'm not sure why vba throws the message and sees 10000 as less than 9###. Do you have any ideas?

.
Hmmm .... I'm using Excel 2007 ... placed a value at row 45,000 ... no problem.

Wonder if it somehow has to do with ver 2016 ? It shouldn't ... the versions are mostly backwards compatible.

I honestly don't know what to say.

Just out of curiosity, highlight Col C / Rt Click and click CLEAR CONTENTS.

Then enter your values all the way down past 10,000 rows again and try it. Maybe there is something of a residual value in the column that can't be
seen.

If that doesn't work ... I'm not certain what to suggest.

.
My apologies .. I misunderstood what you meant 10,000.

Edit the first few lines in the macro to this :

Please Login or Register  to view this content.

Perfect. Works great.

.
You are welcome.

Cheers.