Box Return Values

MsgBox returns a value that indicates which button was pressed. This allows you to take different actions depending on whether the user pressed the Yes, No or Cancel buttons, for example. To get the return value of the Message Box, use an expression like 

RtnValu = MsgBox prompt text, buttons, title text, helpfile, context) 

The InputBox allows you to pause a macro and request input from the user. There are both an InputBox Function and an InputBox method. 

ReturnValu = lnputBox( Enter validation code number , 

---