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 vote242 views1 answer
Vba count all row
VBA
1 vote244 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote256 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote233 views1 answer
Excel vba StartUpPosition
VBA
0 vote242 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
3 votes262 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote253 views1 answer
Convert number to minutes in vba
VBA
2 votes185 views1 answer
Excel vba pause
VBA
0 vote220 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote235 views1 answer
Vbnet check if string is only symbols
VBA