![]() |
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! |
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! |
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! |
All times are GMT +1. The time now is 07:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com