How can I make a macro pause for user input into a dialog box. As a simple
example, If I have the DATAVALIDATION menu open, how can i make it pause
while I set the validation options, and then continue on with the rest of the
macro after the user hits OK?

Thanks