In Excel Video 434 we’ll work through how to capture user input from Message Boxes. Notice how the syntax is slightly different when we need the user’s answer. We define a variable as equal to the Message Box and the Message Box function now needs parentheses. The prompt, buttons, and title have the same syntax as in prior Excel Videos.
We’ll capture the vbYes answer in an If…Then statement, which is a very helpful way to control the way your code goes. We’ll talk more about If…Then in future Excel Videos. I look forward to seeing you then.
