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 vote160 views1 answer
Set datetimepicker value to null vb
VBA
0 vote120 views1 answer
Loop through lines in text file vb net
VBA
3 votes127 views1 answer
Excel insert blank row for value change in column
VBA
0 vote121 views1 answer
Selecttoken em vbnet e json
VBA
0 vote121 views1 answer
Vba integer to double
VBA
0 vote131 views1 answer
Find database connection string vb
VBA
0 vote161 views1 answer
Vbnet add axis labels to chart
VBA
0 vote117 views1 answer
Vba copy paste value only
VBA
0 vote126 views1 answer
Excel vba first working day month
VBA
1 vote122 views1 answer
Excel vba close form escape key
VBA