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 vote233 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote226 views1 answer
Vbscript check if string is empty
VBA
1 vote236 views1 answer
Extract the second word in a text in excel
VBA
-1 vote216 views1 answer
For i in range vba
VBA
0 vote262 views1 answer
Excel vba round to whole number
VBA
0 vote226 views1 answer
Vba horizontalalignment
VBA
0 vote246 views1 answer
Excel vba DisplayAlerts
VBA
0 vote223 views1 answer
Refresh token em vb net
VBA
6 votes232 views1 answer
Excel vba get the path of current workbook
VBA
8 votes369 views1 answer
Excel vba make a short integer from two bytes
VBA