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 vote345 views2 answers
Open url from vba
VBA
5 votes379 views2 answers
Excel vba write to the windows registry
VBA
1 vote344 views2 answers
Get all column names from excel vba
VBA
3 votes351 views1 answer
Excel insert blank row for value change in column
VBA
15 votes460 views2 answers
Xl vba dynamic string array
VBA
0 vote356 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote324 views1 answer
Reset border color textbox vba
VBA
1 vote332 views1 answer
Excel format cell as kilowatts
VBA
0 vote335 views1 answer
Not allow form to be resized
VBA
0 vote320 views1 answer
Vba text to general
VBA