If vbYes = MsgBox("press", vbDefaultButton1 + vbYesNo + vbMsgBoxSetForeground + vbQuestion, "Title") Then
End If
vbDefaultButton 'connects' the first button (here the Yes button) to the enter key.
vbYesNo means that there will be 2 buttons to click on.
vbMsgBoxSetForeground means that what ever happens the messagebox will be put in front of any other form or app.
vbQuestion shows an questionmark icon
You can make you own 'dialogs' by showing a (little) form. Place some commandbuttons on it and/or some little pictures as icons.
Show it with:
Form2.Show vbModal
so the user has to click on it before the app proceeds.
In the commandbuttons of the form take this code to hide the form:
Private Sub Command1_Click()
Form2.Hide
End If
Now your app continues on the next line of code after this line:
Form2.Show vbModal