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 vote236 views1 answer
Change "location" of binding navigator vb
VBA
0 vote260 views1 answer
Vbs exec hidden
VBA
-1 vote250 views2 answers
Excel vba delete empty rows
VBA
0 vote252 views1 answer
Vba extract filename from path
VBA
0 vote229 views1 answer
Excel vba extract year
VBA
0 vote245 views1 answer
VB get external IP address
VBA
0 vote242 views1 answer
VBA Loop to range
VBA
0 vote253 views1 answer
Find database connection string vb
VBA
1 vote192 views1 answer
Vba exit do while
VBA
0 vote235 views1 answer
Vba text to general
VBA