VBA numerical range/limit.

[suedavies123]

I'm trying to create VBA for a simple grading system. User enters score in text box...if they input letters message box asking for numbers only appears,
would like also for them only to input numbers between 0 and 100 with message box if they put higher or lower values in. I cant get the later working. wondering if its as simple as my code being wrong?

Please Login or Register  to view this content.

[shg]

Wouldn't it be easier to put the grades in cells with data validation (allow decimal numbers between 0 and 100) and use simple formulas to average and determine pass/fail?

Please edit your post to add CODE tags. The forum rules explain how.

[suedavies123]

apologies thought I had added tags. it might be easier but I have got this far and this has bought me to a halt. if there is no way of doing it then i will go back to the drawing board...

[shg]

Thanks for the code tags.

Please Login or Register  to view this content.

[suedavies123]

WOW...you are one clever person! Thank you! It works a dream.

[shg]

You're welcome.