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

2 votes325 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote309 views1 answer
Dynamic array vba
VBA
0 vote321 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote338 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote338 views1 answer
Vba remove the first character of string
VBA
0 vote306 views1 answer
Select case vba
VBA
0 vote330 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote292 views1 answer
Vba first line of string
VBA
1 vote300 views1 answer
Excel vba last row of range
VBA
0 vote371 views1 answer
Visual basic cmd
VBA