This works really well, thanks. Do you know where I can find a list of all
the dialog box's exact names?

"Jim Rech" wrote:

Sub a()
MsgBox "Before show"
Application.Dialogs(xlDialogDataValidation).Show
MsgBox "After show"
End Sub

--
Jim
"kayabob" wrote in message
...
| 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