Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Public Sub UserDate()
- Dim strDate As String
- strDate = InputBox("Insert date in format dd/mm/yy", "User date", Format(Now(), "dd/mm/yy"))
- If IsDate(strDate) Then
- strDate = Format(CDate(strDate), "dd/mm/yy")
- MsgBox strDate
- Else
- MsgBox "Wrong date format"
- End If
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement