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

1 vote183 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote187 views1 answer
Vba compare strings
VBA
0 vote218 views1 answer
Filesystemobject vba reference
VBA
0 vote189 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote179 views1 answer
Vbscript Trim
VBA
3 votes175 views1 answer
Excel vba read registry key value
VBA
0 vote206 views1 answer
Columns dont autoresize on program start vb.net
VBA
4 votes192 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote183 views1 answer
Vbs expand env var
VBA
5 votes199 views1 answer
Excel vba low word from Long Integer
VBA