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 vote164 views1 answer
Vba count all row
VBA
0 vote146 views1 answer
Vbs
VBA
0 vote141 views1 answer
Vba timestamp -- milliseconds
VBA
5 votes165 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
4 votes151 views2 answers
Excel vba last column with data
VBA
0 vote143 views1 answer
Vba add month to date
VBA
2 votes139 views1 answer
Vba uppercase first letter of each word
VBA
1 vote146 views1 answer
Add control vb
VBA
0 vote158 views1 answer
Vba horizontalalignment
VBA
0 vote165 views1 answer
Vba round to 2 decimals
VBA