ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Looping through a user defined type? (https://www.excelbanter.com/excel-programming/359941-looping-through-user-defined-type.html)

plh

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!

Jim Thomlinson

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!


K Dales[_2_]

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