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 vote349 views1 answer
Excel filter by date not working vba
VBA
0 vote365 views1 answer
Excel vba set cell value to empty
VBA
0 vote346 views1 answer
Excel vba select multiple shapes
VBA
0 vote325 views1 answer
Vbs write file
VBA
22 votes508 views1 answer
Excelvba check for directory
VBA
3 votes325 views1 answer
Vba folderexists
VBA
0 vote357 views1 answer
Excel named range sum
VBA
0 vote377 views1 answer
Vba search string position
VBA
0 vote326 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote368 views1 answer
Method showalldata of object _worksheet failed vba
VBA