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 vote239 views4 answers
Vgrive,deb
VBA
0 vote244 views1 answer
Vba sheet hide unhide
VBA
4 votes240 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
1 vote240 views1 answer
Set font for ms chart vb.net
VBA
0 vote230 views1 answer
Vba len variant
VBA
18 votes405 views3 answers
Excel-vba make integer
VBA
2 votes217 views1 answer
Vba uppercase first letter of each word
VBA
3 votes241 views1 answer
Vba post request json
VBA
0 vote236 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote232 views1 answer
Date as number vb
VBA