VBA . validating user entered data (via inputbox) and error handler

[rain4u]

Hi all
I have this code where the first inputbox asks the user to insert year e.g. 2011 and second inputbox asks to enter week number e.g. 52.
How can validate that user indeed selected the a valid year number lets say number between 2000 and 2100 (yes I believe no one will use excel in its current form after 2100 ), and with week number it can be number between 1 and 52. Error handler should exit the sub and prompt with a message. Like "not a valid year" or "not valid week number"

Code itself looks following:

Please Login or Register  to view this content.

If anyone knows how to do it, I would appreciate the help.
Cheers
Rain

[Mordred]

Hi rain, try to incorporate this into your procedure

Please Login or Register  to view this content.

I would but I am now leaving the building.