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 vote123 views1 answer
Open application from vbnet
VBA
5 votes153 views1 answer
Excel vba get low byte from INTEGER
VBA
5 votes148 views1 answer
Vba low byte from INTEGER
VBA
20 votes284 views1 answer
Excel vba factorial
VBA
0 vote140 views1 answer
Vba vbcrlf chr
VBA
0 vote133 views1 answer
Excel vba disable keyboard input
VBA
0 vote133 views1 answer
Send text to clipboard vb.net
VBA
0 vote123 views1 answer
Vba code for cutoff time
VBA
2 votes134 views1 answer
Excel vba date to string conversion
VBA
0 vote123 views1 answer
How to use VBA to add new record in MS Access?
VBA