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 vote178 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote176 views1 answer
WGET FTP
VBA
0 vote166 views1 answer
Vbnet get file name from path
VBA
0 vote166 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote202 views1 answer
Excel vba round to whole number
VBA
2 votes166 views1 answer
Vba split string
VBA
0 vote179 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
22 votes347 views1 answer
Xl vba check for folder
VBA
5 votes199 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote183 views1 answer
Check if program is running vbnet
VBA