Call Object_Exit : Type mismatch

  • Thread starter Thread starter Kevin McCartney
  • Start date Start date
K

Kevin McCartney

Hi,
I'd like to run the following code but get a Compile
error: "Type mismatch"

Call cboProduct_Exit(False)
the procedure that I want to call has the following
parameters

Private Sub cboProduct_Exit(ByVal Cancel As
MSForms.ReturnBoolean)

any ideas on how to make this work would be much
appritiated.

cheers
TIA
KM
 
Call cboProduct_Exit(False)

Private Sub cboProduct_Exit(ByVal Cancel As Boolean)

Just sue the Boolean type by itself

Patrick Molloy
Microsoft Excel MVP
 
Put the code in a common sub and have the Exit event call that as well as
your code.

Otherwise you can try

Dim bBool as MSForms.ReturnBoolean
bBool = False
Call cboProduct_Exit(bBool)

Untested.
 
Back
Top