View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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