Guest User

Untitled

a guest
Feb 20th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. Sub YesNoMessageBox()
  2. Dim answer As String
  3. Dim message As String
  4. Dim i As String
  5. handlingPathError:
  6. i = InputBox("Enter a number")
  7. message = "Pfad ungueltig, moechten Sie erneut auswaehlen?"
  8. On Error GoTo errHandler
  9. MsgBox (1 / CInt(i))
  10. Exit Sub
  11. errHandler:
  12. If Err.Number = 11 Then
  13. answer = MsgBox(message, vbQuestion + vbYesNo, "EKC Bot")
  14. If answer = vbNo Then
  15. 'Code for No button Press
  16. Exit Sub
  17. Else
  18. 'Code for Yes button Press
  19. Resume handlingPathError
  20. End If
  21. End If
  22. End Sub
Add Comment
Please, Sign In to add comment