Userform textfield to show the max value from a column

Hi,
I would like to display the maximum value of column N on sheet 'Data Entry' on my userform. I would like the new display to be display only and not look like a user entry field, is that possible?
Thanks!

Add a UserForm Label, Named lblMaxValue

In the code

Please Login or Register  to view this content.

Thanks, this works great , but i have a glitch.
The values i am working with to find the max are the result of a MID formula, to strip out alpha characters from another cell. So for example, column B has values like AH3, AH4 etc and my new column N uses =MID(B2,3,3) to strip off the AH and return 3, 4, etc. Then I want to find the max of column N. Is there a way to automatically change the results of my MID formula so they are true values and can use the MAX formula?