Error Prevention Application.InputBox

I am trying to add error prevention to my macro.

Please Login or Register  to view this content.

In all dialog box prompts for user input, if a character is input when the a numberic is requested or the user selects the Cancel button, the macro exits.

This works just as intended. However, for the code in red, if the user inputs a numeric instead of a character, the type:=2 critieria is ignored, the macro accepts the input (when it should not), and moves on to the next dialog box. Additionally, if the user selects the Cancel button, the macro moves on to the next dialog box instead of exiting. What additional code is needed to prevent the macro from proceeding to the next dialog box?

Ok, I think I see what you are saying - since the variable is defined as a string, a numeric value entered into a string defined variable will be treated as a string. Thus, the macro accepts the input and proceeds.

If I followed correctly, then I propose the following:

Please Login or Register  to view this content.

The problem I am having with this approach is that if the input happens to be a value, the macro exits the sub. I thought by adding:

Please Login or Register  to view this content.

that the macro would return to the section of the code causing the problem until the input is corrected.

However, this is not happening. The macro just proceeds.

What do I need to do?

Thanks for the feedback.