I'd like to return an array with several variables of a user-defined type from a function. Couldn't find a solution!
I get a Compile error on Function() As Variant:
"Only user-defined types defined in public object modules can be coerced to or from a variant or passed to late-bound functions"
and a Compile error on Function As Variant:
"Type mismatch"
Any help is appreciated, thank you
Please Login or Register to view this content.
You can get rid of that error by changing the function declaration of fTest to return typeX() instead of Variant.
If posting code please use code tags, see here.
Thanks you!, SOLVED
How could I not find this myselve!!!!
This gives me an other question:
Can I have 2 different types of user-defined variables info 1 array and return that from a function?
So the function probably can't be declared as just 1 type...
declare it as Variant and then it can return anything :-)
Josie
if at first you don't succeed try doing it the way your wife told you to
I get the error: Can't assign to array
Please Login or Register to view this content.
my bad-that doesn't work in vba-you'd be better off using classes than udts
I tried classes, but it's a pain in the ***.
And using a UDT for this is a walk in the park?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks