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 vote209 views1 answer
Excel vba move down to next visible cell
VBA
0 vote183 views1 answer
How to extract a file from an ISO:
VBA
2 votes204 views2 answers
Excel vba if sunday or staurday
VBA
0 vote180 views1 answer
Vba change named range address
VBA
0 vote187 views1 answer
VBA Sleep Snippet
VBA
1 vote178 views1 answer
Vba reverse string
VBA
1 vote179 views1 answer
VBA Loop through recordset
VBA
0 vote182 views1 answer
Vba leading zeros in string
VBA
0 vote181 views1 answer
Find days in month vba
VBA
0 vote239 views1 answer
Find control with name vb
VBA