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 views1 answer
Returns an array from function vba
VBA
0 vote175 views1 answer
Vbnet revrese the order of character in string
VBA
31 votes293 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote172 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote176 views2 answers
Vba remove line breaks
VBA
0 vote178 views1 answer
Dynamically change drop down list visual basic
VBA
5 votes184 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote170 views1 answer
Move bindingnavigator vb
VBA
0 vote186 views1 answer
Excel vba set cell value to empty
VBA
0 vote168 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA