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 vote212 views1 answer
Excel vba protect content
VBA
8 votes215 views1 answer
Excel vba make word
VBA
22 votes309 views1 answer
Excel vba check if directory exists
VBA
0 vote164 views1 answer
Excel vba saveas no prompt for overwrite
VBA
-1 vote190 views1 answer
How save excel through visual basic
VBA
0 vote165 views1 answer
Excel vba combine ranges
VBA
22 votes299 views1 answer
Xlvba check for folder
VBA
0 vote196 views1 answer
Vb ternary
VBA
0 vote169 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote174 views1 answer
String contins in vba
VBA