Do you have any information on UDTs on your website? If not, do you know a
good reference website or book with advanced programming text for VBA?

I have little explanatory material on the web site regard UDTs, and
that is only as prelude to the discussion on classes and objects. You
can't loop through the contents of a UDT. The is no way to write a
generic proc to reset a UDT. You have to have one for each type.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 19 Nov 2008 12:23:15 -0800, RyanH
wrote:

Chip,

Do you have any information on UDTs on your website? If not, do you know a
good reference website or book with advanced programming text for VBA?

Is there a way to loop thru the UDT? I will need to reset the UDT for 15
Userforms so it would be benifical to have a "one size fits all" procedure to
reset the UDT instead of explicitly setting each variable in the type to 0.
For example,

Sub ResetUDT(ByRef UDT As Variant)

Dim var As Double

For Each var In UDT
var = 0
Next var

End Sub