Classes in VBA?? 1

[JoeSmoe55]

Please forgive me for my ignorance and inexperience but I was wondering if it is possible to write classes in VBA and if so, do you have a good link to a site where I might learn. Also, I would like tips on how to search for this info without bugging you guys with silly questions. I alway resort to google searches. Thanks for your patience and grace.

Joe

 

[Zion7]

Yes it is possible to write classes in VBA.

Not considered to be an "Object Oriented Language", in the full sense, it does though, come very close.
I think the only attribute it lacks to qualify is, "inheritance". Which I believe is more of a convenience quality in regards to development, than functional.

I don't know of any sites in particular, but I anticipate there's many, for it's not uncommon at all.

I wrote a couple of very simple ones myself, just to get the gist of it. So again, yes, it's very possible.

But just for the record, I understand that any class one writes, can be written as a procedure or function. So I have yet to find a real need for it. I think it helps a great deal when developing in teams. And offers a very familiar interface as you can access methods and properties of your class, the same way you do in VBA.

Prepare yourself, there's a bit of a learning curve....


Good luck!

 

[markphsd]

It's not OOP but you can get some good use out of it.

For example, I have classes written to open a recordset and then load the values into properites. I can then manipulate these properties until i'm ready to call a functions of the class that updates the actual record. This is great for disconnected forms.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[redapples]

have a look at this -

http://www.di-mgt.com.au/classes.html

I too have common classes I use a lot particularly for ADO manipulation. They do work well for unbound forms.

Want the best answers? See FAQ181-2886