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 vote201 views1 answer
What does vbs stand for
VBA
0 vote192 views1 answer
Excel vba populate array with cell values
VBA
0 vote238 views1 answer
Excel vba unlock sheet without password
VBA
1 vote208 views1 answer
Excel vba autofit
VBA
0 vote198 views1 answer
Enter into cells data grid view
VBA
4 votes153 views2 answers
Vba last row
VBA
0 vote224 views1 answer
Vba table header name
VBA
0 vote216 views1 answer
Excel vba convert cells address
VBA
0 vote226 views1 answer
Excel vba set cell value to empty
VBA
5 votes183 views1 answer
Vba array worksheet.index
VBA