Object Oriented Programming

[yoko]

Hi,

I’m trying to learn more about Object Oriented Programming for VBA. Does anyone know any good tutorial sites etc?

Many thanks!

 

[Emanresux]

Haven't really go any links to give you but you could try learning visual basic
You can down load Visual Basic 2005 express edition for free from Microsoft. The help file is very extensive and there are loads of tutorials on the web. This way you can learn OOP and when you come back to VBA it will be easy

 

[yoko]

I've got a pretty good understanding of what OOP is and have been using VBA for a while but I've never actually used OOP in any code, i.e. creating my own classes etc. I'm reading through the MSDN site now trying to grasp some of the details!

Cheers

 

[Richard Schollar]

Here's a very good book which has an excellent section on developing classes (VBA Developer's Handbook, Sybex) - it should be on every VBA programmer's bookshelf:

http://www.amazon.com/gp/product/07...507846&s=books&v=glance&tag2=dailydoseofex-20

 

[SydneyGeek]

Here's a very good book which has an excellent section on developing classes (VBA Developer's Handbook, Sybex) - it should be on every VBA programmer's bookshelf

Definitely. Also:
Excel 2002 VBA Programmer's Reference (Bullen, Green, Bovey & Rosenberg), Sybex
Excel Professional Development (Bullen, Bovey & Green), Addison Wesley

And check out this intro on Chip Pearson's site:
http://www.cpearson.com/excel/ClassModules.htm

Denis