Create Pop-up Error

Hello,
I'm reading up on and learning VBA slowly.

I'm trying to create a pop-up error within a macro.
The macro is as follows:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

if you notice i'm trying to prevent the ability for a user to enter in text into the inputbox, and if they do input text i want the macro to repeat from the first line until the "Fig" = a number.

Can anyone help me out?

Maybe like this:

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

Take a look in VBE Help for InputBox Method and post back if you don't understand it. Type = 1 requires the user to input a number.

You don't need to declare different variables for Num and Ans unless you need to keep them both for some reason. Your code doesn't indicate that you do. You can simply use:

Please Login or Register  to view this content.

And again, a separate variable to store the answer from the MsgBox is also not required, you can simply use if/then on Msgbox itself:

Please Login or Register  to view this content.

If you look at Help, there is an InputBox method (which I used, and accepts a Type argument) and an InputBox function (which you used, and which doesn't).

As you're just starting to learn VBA, you should acquire a good habit at the outset, and start declaring your variables.

Originally Posted by garretonufer

I don't understand. Does VBA automatically reallocate the value for a variable if used in different places throughout the VBA code?

Essentially, yes.

If I declare the Num = 5, then I can re-fill the variable again later with an entirely new number, or, as I've shown, by doing math on the current value. When the math is complete, the result becomes the new value of Num.

Please Login or Register  to view this content.

And you can do that over and over, absolutely. Unless you NEED the different versions of Num, there's no reason not to reevaluate the variable, else you're just cluttering up your macro with lots of little variables. You CAN do that, of course, and it may even make more sense to you. But to me, if the value of Num is changing, it's still the value of Num in my mind and having it just change as needed as we go makes more sense to me, rather than trying to keep track of Num vs Ans vs Final, etc.