Call Object_Exit : Type mismatch
 

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 Object_Exit : Type mismatch
 

Call cboProduct_Exit(False)

Private Sub cboProduct_Exit(ByVal Cancel As Boolean)

Just sue the Boolean type by itself

Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
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 Object_Exit : Type mismatch
 

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.

--
Regards,
Tom Ogilvy

Kevin McCartney wrote in message
...
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