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 vote221 views1 answer
If statement vdhl
VBA
1 vote196 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote190 views1 answer
Open application from vbnet
VBA
4 votes211 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote188 views1 answer
Returns an array from function vba
VBA
0 vote202 views1 answer
Vba copy file
VBA
0 vote197 views1 answer
Vba border weight
VBA
0 vote211 views1 answer
Vba array dimensions
VBA
1 vote195 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote202 views1 answer
Excel vba cell on change
VBA