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

1 vote350 views1 answer
Excel date to unix timestamp
VBA
0 vote431 views1 answer
Vba foreach 2d array
VBA
0 vote348 views1 answer
Vba string start with
VBA
0 vote390 views1 answer
Excel named range sum
VBA
0 vote353 views1 answer
Compare dates vb
VBA
0 vote380 views1 answer
Vba multiple optional arguments
VBA
1 vote375 views1 answer
Vba loop through files in folder
VBA
0 vote356 views1 answer
Vba word open document read only
VBA
1 vote367 views1 answer
Excel vba compare 2 rows
VBA
3 votes351 views1 answer
Vba make long from two shorts
VBA