Error Diagnosis - Where is the error?

[Jim Shaw]

When I save my form I get this kind of message:

"The expression On Click you entered as the event property
setting produced the following error:User-defined type not
defined."

I have many, many "On Click" events coded in VBA. How can
I find the one in trouble?

I've scanned my code and can't find any undefined user
types.

Thabnks

-Jim

 

[Jim Shaw]

I figured it out myself.
Use: Debug.TestCompile
Takes you right to the problem.

Thanks anyhow
-Jim