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 vote296 views1 answer
Putting marquee in vb.net
VBA
0 vote319 views1 answer
Vba code to open a file with login rights
VBA
1 vote329 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote321 views1 answer
Convert number to minutes in vba
VBA
20 votes457 views1 answer
Excel vba recursive example factorial function
VBA
0 vote319 views1 answer
Vba collection key list
VBA
0 vote295 views1 answer
Excel vba populate array with cell values
VBA
0 vote299 views1 answer
Check if program is running vbnet
VBA
0 vote321 views1 answer
Thread sleep vb
VBA
0 vote297 views1 answer
Vba apostrophe chr
VBA