Excel 2007 : Compile error in passing variables to a function

[CFA-VBA]

Greetings,

when trying to call the following function "ComplexOp1()", I get the following message: "Compile error: Only user-defined types in public object modules can be coerced to or from a variant or passed to late-bound function". The variable "CNum2" in the line "Case 1: cNum3 = cNumConj(cNum2) " gets highlighted by the compiler.

here is the function ComplexOp1:

Please Login or Register  to view this content.

here's the "set_cNum" function that gets called in "ComplexOp1":

Please Login or Register  to view this content.

--Does anyone now what the error message means? Thanks.

[tlafferty]

Welcome to the forum! A couple of things:
1) please re-read the forum rules about how to enclose your code in code tags so it will display properly.
2) Take a minute to define rP1 and iP1 to do.

You have not defined them properly. Take a look at the help topic on data conversion functions for better understanding.

[CFA-VBA]

Hi tlafferty,

the previous code has been tagged now; in regards to point #2, when you say "define rP1 and iP1", you mean defining their datatype when passing them into function "ComplexOp2" like this ?

Please Login or Register  to view this content.

Also, here's the datatype defined prior for cNum that uses rP1 & iP1 in functions that wasn't included in my first post:

Please Login or Register  to view this content.