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 vote169 views1 answer
Check if program is running vbnet
VBA
0 vote179 views1 answer
Add text to combobox drop down vb
VBA
0 vote162 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote159 views1 answer
Vbnet add new ecel sheet
VBA
1 vote177 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote176 views1 answer
Get month number from month name vbnet
VBA
0 vote162 views1 answer
How to extract a file from an ISO:
VBA
0 vote164 views1 answer
Vbnet get file name from path
VBA
2 votes169 views2 answers
Excel vba copy values range to another range
VBA
0 vote168 views1 answer
Vbnet check if string is only symbols
VBA