Call Sub Procedure object_Exit(ByVal Cancel As MSForms.ReturnBoole

  • Thread starter Kevin McCartney
  • Start date
K

Kevin McCartney

I have a private sub procedure that I want to call from another private sub
procedure, but I get the error message Type mismatch


the sub procedure I want to call is "Private Sub txtExpectedDate_Exit(ByVal
Cancel As MSForms.ReturnBoolean)"

and I call it by "txtExpectedDate_Exit (False)"

So the questions is what is the correct code to call a private sub procedure
object_Exit?

TIA
KM
 
K

Kevin McCartney

This code works .... Call txtExpectedDate_Exit(Cancel) it must be a
Friday thing :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prompt For Replace in Selection And More... 0
Which Excel event to call when opening a .txt file 1
Can't disable RIGHT CLICK 1
Use BeforeDoubleClick to place 1 or 4 character in a cell 1
VBA Excel Macro worked for 2-years now dosen't?? 11
Using a Range variable to call a procedure with a ByVal statement... 14
Run time error 2
Shorter way to create multiple identical Event Procedures? 7

Top