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

1 vote124 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote129 views1 answer
Average vba
VBA
0 vote126 views1 answer
Vba string
VBA
0 vote136 views4 answers
How to continue formula in below line in vba code
VBA
0 vote127 views1 answer
Excel vba named range exists
VBA
0 vote124 views1 answer
Excel vba unmerge sheet
VBA
0 vote118 views1 answer
Vbnet display all axis labels in cahrt
VBA
1 vote118 views1 answer
VBA Loop through recordset
VBA
1 vote115 views1 answer
Vba delete array element
VBA
0 vote133 views1 answer
Sort dictionary by key vba
VBA