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

3 votes285 views2 answers
Excel "vba" match last value
VBA
0 vote327 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote279 views1 answer
Vba line feed
VBA
1 vote321 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote275 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote291 views1 answer
Excel vba select multiple shapes
VBA
0 vote277 views1 answer
Refresh token em vb net
VBA
1 vote282 views1 answer
Excel format cell as kilowatts
VBA
8 votes317 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote279 views1 answer
Set column width of datagridview vb.net
VBA