Verifying user input from InputBox

[nbuk]

I have a macro which asks the user to input several values and then I need to test and see if they are valid. Here is the current code that I have

Please Login or Register  to view this content.

The issue I am having is that if the user enters a decimal it will be accepted. Also I want to be able to cancel the input, i.e. if the user presses cancel the input box will disappear.

Can anyone please offer me any suggestions to improve the code?

[royUK]

Why not create a UserForm it would be much more professional looking