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 vote230 views1 answer
Vb get ip address
VBA
25 votes280 views2 answers
Excel vba folder exist
VBA
0 vote238 views1 answer
Vba array dimensions
VBA
0 vote212 views1 answer
Vb test if reference is null
VBA
0 vote223 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote234 views1 answer
Create links in msgbox in vb
VBA
1 vote222 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote228 views1 answer
Vba code for cutoff time
VBA
0 vote213 views1 answer
Excel vba current folder
VBA
0 vote228 views1 answer
Vba get workbook name
VBA