vbCancel = True

[theta]

Hi,

I have the following section of VBA code which works :

CONTRACT = Application.InputBox("Please enter Contract no", "LIFT DETAILS")
If CONTRACT = False Then
Exit Sub
End If

I would rather use the vbCancel object but it gives me 13 error :

CONTRACT = Application.InputBox("Please enter Contract no", "LIFT DETAILS")
If vbCancel = True Then
Exit Sub
End If

Help please?

 

[Andrew Poulsom]

Sorry, that's not possible. vbCancel (value 2) is a member of vbMsgBoxResult and there is no such Enum for an InputBox.

 

[theta]

I was told if I asked excel nicely it might work? No?

 

[RoryA]

No. As a great man once said "this is programming, not magic, unfortunately".