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 vote169 views2 answers
Excel vba copy paste after last row
VBA
1 vote173 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
3 votes179 views1 answer
Vba make long from two shorts
VBA
0 vote186 views1 answer
Vba array of integers
VBA
1 vote130 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote225 views1 answer
Visual basic run command
VBA
0 vote186 views1 answer
Vba keep command window open
VBA
1 vote170 views1 answer
Vba reverse string
VBA
2 votes178 views1 answer
Excel vba date to string conversion
VBA
0 vote181 views1 answer
Excel vba urlmon
VBA