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

20 votes532 views1 answer
Excel vba recursive example factorial function
VBA
0 vote234 views1 answer
Vba get text file content
VBA
0 vote248 views1 answer
Excel vba prevent saving workbook
VBA
0 vote272 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote239 views1 answer
Create links in msgbox in vb
VBA
8 votes316 views1 answer
Vba make integer
VBA
0 vote271 views1 answer
Vba timestamp -- milliseconds
VBA
15 votes532 views2 answers
Xl vba dynamic string array
VBA
0 vote240 views1 answer
Show unix time in vba
VBA
0 vote241 views1 answer
Excel run macro every 5 minutes
VBA