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 vote200 views1 answer
Vba add shape oval
VBA
0 vote209 views1 answer
Excel vba cell on change
VBA
5 votes237 views1 answer
Excel vba get user selected range
VBA
0 vote209 views1 answer
Excel vba chrw max value
VBA
0 vote219 views1 answer
Search combobox items vb.net
VBA
1 vote221 views2 answers
Excel vba password protect
VBA
0 vote281 views1 answer
Excel vba add reference programmatically
VBA
0 vote210 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote220 views2 answers
Excel vba protect cells with formula
VBA
0 vote224 views1 answer
.net dark title bar
VBA