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 vote279 views1 answer
Afficher un message d'erreur vba
VBA
0 vote273 views1 answer
Excel vba move down to next visible cell
VBA
8 votes316 views1 answer
Run command pormpt in background windows
VBA
5 votes321 views2 answers
Excel vba write to the windows registry
VBA
0 vote266 views1 answer
Vbs expand env var
VBA
0 vote260 views1 answer
Excel vba disable mouse click
VBA
1 vote269 views1 answer
Vba delete file
VBA
0 vote268 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote262 views1 answer
Check range is in another range vba
VBA
0 vote264 views1 answer
How to use VBA to add new record in MS Access?
VBA