Determine last number in a column that contains numbers, and strings

All,

I'm trying to figure out how to determine the last number in a column, with a caveat. The column will contain both integers (ascending), and strings (also ascending, but the format is variable, and not required for this exercise).

What I would like to do, is have a button on a userform that when clicked looks at the column, finds the last number used and increments it by 1. There may be white space between the current cell and the number, there may also be a string in the way. Example attached

Many thanks for the help!


sample_help.xlsx

Bonus points: Looking at the example file, is there a simple routine I could use to increment the string? The data will virtually always have the same format, with 2 incrementing characters at the end. In extremely rare cases it might extend to 3 characters. If not found, create first example + 01 at the end


I've done pretty well with my vba so far, but this one has me stumped :/