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

3 votes354 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote347 views1 answer
Vba horizontalalignment
VBA
0 vote332 views1 answer
Excel vba existence of a file
VBA
0 vote381 views1 answer
Create links in msgbox in vb
VBA
0 vote346 views1 answer
Select case vba
VBA
0 vote381 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
1 vote365 views1 answer
Vba format string as cash
VBA
1 vote373 views1 answer
Vba optional
VBA
0 vote418 views1 answer
Visual basic run command
VBA
0 vote362 views1 answer
For each item in folder outlook vba
VBA