If inputbox cancel vba

Private Sub test()
    Dim result As String
    result = InputBox("Enter Date MM/DD/YYY", "Date Confirmation", Now)
    If StrPtr(result) = 0 Then
        MsgBox ("User canceled!")
    ElseIf result = vbNullString Then
        MsgBox ("User didn't enter anything!")
    Else
        MsgBox ("User entered " & result)
    End If
End Sub

Source: stackoverflow.com

Similar codes

0 vote149 views1 answer
Vba add shape oval
VBA
0 vote159 views1 answer
Visual basic msdos
VBA
1 vote163 views1 answer
How to check is the value enterd is a number or text in vba
VBA
-1 vote185 views1 answer
How save excel through visual basic
VBA
0 vote162 views1 answer
Vba html document reference
VBA
4 votes111 views2 answers
Vba last row
VBA
1 vote1.1K views1 answer
Vba Remove Case Sensitivity
VBA
5 votes162 views1 answer
Xl vba double quotes in string literal
VBA
0 vote160 views1 answer
Vba compare strings
VBA
6 votes180 views1 answer
Excel vba isalpha
VBA