Class programming in 2010 (or 2013).

[Darren Bartrup]

Could anyone recommend a book which will take me through class programming and event handling in VBA?

I know the basics but would like a fully comprehensive book that covers all of it.

I'm sure someone can help

Thanks, Darren.

 

[Jon von der Heyden]

Yup! Excel VBA 2007 by Wrox. Its a programmers reference so not especially tutorialised but it's a very good book. Also, spend some time researching some articles at some other websites.

cpearson.com was particularly helpful when I was learning to write classes.

Also sometimes there are good articles that make good use of classes but the emphasis isn't on teaching people how to program classes. I found a few articles at JKP very handy for learning classes indirectly.

 

[hiker95]

Darren Bartrup,

See if any of the below links will help you:

Here is a good introductory tutorial using a VBA Class:
Classes In VBA

Events And Event Procedures In VBA
Events In Excel VBA

 

[taurean]

There's a chapter on classes in VBA Developer's Handbook which is also good.
VBA Developer's Handbook, 2nd Edition: Ken Getz, Mike Gilbert: 0025211229781: Amazon.com: Books

 

[Darren Bartrup]

Thanks for the pointers - I'll have a look at the Wrox books as I've found them useful in the past.

I'm a regular visitor to Chip Pearsons site which is where I've learnt about classes up until now (along with what I know about C# and OOP).

Cheers,
Darren.

 

[hiker95]

Darren Bartrup,

You are very welcome. Glad we could help.

And, come back anytime.