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 vote213 views1 answer
Vb net show lines for all axis labels in chart
VBA
31 votes507 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote217 views1 answer
Excel vba disable mouse click
VBA
0 vote225 views2 answers
Do until loop vba
VBA
0 vote232 views1 answer
Vba sheet hide unhide
VBA
5 votes242 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote219 views2 answers
Get excel file from email attachment in vba
VBA
1 vote234 views1 answer
Set font for ms chart vb.net
VBA
0 vote226 views1 answer
Vba first line of string
VBA
0 vote204 views1 answer
Excel vba populate array with cell values
VBA