Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I created a UDT called VECTOR containing three doubles (i.e., x,y,z). I also
created a set of UDF's that I want to have inputs of either a range of 3 cells, an array of values (ints, longs, or doubles), or of my UDT VECTOR. The problem is that I can't seem to get TypeName(VECTOR_variable) to return VECTOR. That is, I need something to quickly tell me that the input to this function is my user defined type VECTOR. I am getting the error message that says: "only user-defined types defined in public object modules can be coerced to or from a variant or passed to late-bound functions" How can I get around this? I don't know anything about class modules, and I really don't want to get that in depth (yet). Thanks, Pflugs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I know selected picture is a shape but typename says is picture | Excel Programming | |||
Rephrasing argument for typename and a different result | Excel Programming |