Add a Yes / No message in code

[daniels012]

I need to add to exsisting code:

If msgbox "Have you printed your worksheets yet?" (new line)

i need them to be able to choose "Yes" Then code below would execute.
Or "No" then the code would end without going further.

Any help, thank You

Michael

 

[Norie]

Michael

Something like this?

rsp = MsgBox("Have you printed your files yet?", vbYesNo)
Select Case rsp
      Case vbYes
             ' execute code
      Case vbNo
             Exit Sub
             ' End
End Select

 

[Jon Peltier]

Dim lResponse as Long
lResponse = MsgBox("Have you printed your worksheets yet?", vbQuestion + vbYesNo)
If lResponse = vbNo then Exit Sub

 

[Jonmo1]

If MsgBox("Have you printed your worksheets yet?", vbYesNo) = vbNo Then Exit Sub

 

[njimack]

Sub test()
Dim Question As VbMsgBoxResult

Question = MsgBox("Have you printed your worksheets yet?", vbQuestion + vbYesNo, "Answer me NOW!")

If Question = vbNo Then Exit Sub

'your code here

End Sub

 

[HalfAce]

Michael,
Take your pick!
(I like the title in njimack's example)