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

13 votes286 views2 answers
Vba write text file
VBA
0 vote159 views1 answer
Arq linux
VBA
1 vote152 views1 answer
Vba date to unix timestamp
VBA
0 vote196 views1 answer
Visual basic cmd
VBA
1 vote103 views1 answer
How to open cmd with vbd
VBA
0 vote146 views1 answer
Do while not vb.net
VBA
0 vote140 views1 answer
Find days in month vba
VBA
0 vote162 views1 answer
Write listbox to text file vb.net
VBA
0 vote152 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote154 views1 answer
Group controls programmatically vb
VBA