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 vote250 views1 answer
Vba paste values
VBA
0 vote249 views1 answer
Vba character ascii code
VBA
0 vote226 views1 answer
Vbnet find highest value in chart
VBA
0 vote256 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote231 views1 answer
Excel vba linter
VBA
0 vote209 views1 answer
Vba argument is set
VBA
0 vote202 views1 answer
Vbnet make a string to unicode converter
VBA
8 votes507 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote182 views1 answer
Excel vba arrondir
VBA
5 votes252 views1 answer
Excel vba tool to help with refactoring code
VBA