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

1 vote150 views1 answer
Vba reverse string
VBA
1 vote178 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
1 vote153 views1 answer
Add control vb
VBA
0 vote200 views1 answer
Excel vba delete columns in range
VBA
0 vote147 views1 answer
Excel vba disable screen update
VBA
0 vote152 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote156 views1 answer
Vbnet cycle through charaters in string
VBA
1 vote162 views1 answer
Excel vba force recalculation
VBA
6 votes167 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote194 views1 answer
Vbnet add axis labels to chart
VBA