Advertisement
Guest User

Untitled

a guest
Nov 13th, 2019
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Public Sub UserDate()
  2.   Dim strDate As String
  3.   strDate = InputBox("Insert date in format dd/mm/yy", "User date", Format(Now(), "dd/mm/yy"))
  4.   If IsDate(strDate) Then
  5.     strDate = Format(CDate(strDate), "dd/mm/yy")
  6.     MsgBox strDate
  7.   Else
  8.     MsgBox "Wrong date format"
  9.   End If
  10. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement