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 vote290 views1 answer
Convert unix to date vba
VBA
1 vote286 views1 answer
Sort using vba
VBA
0 vote281 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote296 views1 answer
Excel vba hide gridlines
VBA
1 vote339 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote292 views1 answer
Vba add shape oval
VBA
0 vote312 views1 answer
Create links in msgbox in vb
VBA
1 vote286 views1 answer
Excel vba autofit
VBA
1 vote297 views1 answer
Export datagridview to excel vb.net
VBA
0 vote265 views1 answer
Enter into cells data grid view
VBA