Geek asks and answers

Is it possible to define an array of structures or objects in VBA?

I need to implement something in an Excel macro (yuk!), For which I would like to use an array of structures or objects. (Is this even possible at all in Excel VBA?)

The problem is that I can find very scarce documentation. Can someone please provide some recommendations for good VBA documentation or a suggestion on using VBA structures?

+5
source share
1 answer

Perhaps a type structure is what you are looking for?

http://www.cpearson.com/excel/classes.aspx (scroll down a bit)

Then, I suppose, you would use this in conjunction with VBA arrays.

http://www.cpearson.com/excel/vbaarrays.htm

Hope this helps.

+6
source

More articles:


All Articles