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 vote144 views1 answer
Vba multiple optional arguments
VBA
0 vote122 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote135 views1 answer
Vba exit while
VBA
0 vote121 views1 answer
Vba first line of string
VBA
0 vote117 views1 answer
Vba test optional argument
VBA
0 vote121 views2 answers
Excel vba close without saving
VBA
0 vote162 views1 answer
Set datetimepicker value to null vb
VBA
0 vote128 views1 answer
Change form background image vb
VBA
1 vote126 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote130 views1 answer
Columns dont autoresize on program start vb.net
VBA