Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through a user defined type?
Is there a way of looping though a user defined type without having to name each
element? Something that would amount to: For each Thing in myUserDefinedType 'Dosomething Next Thing In the one I am concerned with there are user defined types within myUserDefinedType in addition to strings, integers, etc. Thank You, -plh -- I keep hitting "Esc" -- but I'm still here! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through a user defined type?
To th ebest of my knowledge you can not loop through a UDT...
-- HTH... Jim Thomlinson "plh" wrote: Is there a way of looping though a user defined type without having to name each element? Something that would amount to: For each Thing in myUserDefinedType 'Dosomething Next Thing In the one I am concerned with there are user defined types within myUserDefinedType in addition to strings, integers, etc. Thank You, -plh -- I keep hitting "Esc" -- but I'm still here! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through a user defined type?
You need a Collection object - see this reference:
http://msdn2.microsoft.com/en-us/library/yb7y698k.aspx -- - K Dales "plh" wrote: Is there a way of looping though a user defined type without having to name each element? Something that would amount to: For each Thing in myUserDefinedType 'Dosomething Next Thing In the one I am concerned with there are user defined types within myUserDefinedType in addition to strings, integers, etc. Thank You, -plh -- I keep hitting "Esc" -- but I'm still here! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
Workspace faux user-defined type not defined | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
Word.Document - user defined type not defined | Excel Programming |