Styles of programming in VBA

[tiredofit]

I have come to the conclusion there appears to be two distinct styles of programming in VBA.

1. Those with no prior experience of programming.
2. Others who are already conversant with Java, C#, etc.

I have seen VBA code such as:

Function MyFunc (somearg As Burger) As McDonalds

and then I start to panic as I believe this has been written by someone who has a formal training in programming because Burger and McDonalds (in my humble opinion) are classes.

Most VBA books focus on getting programs written without delving too deeply into classes, collections, etc.

Can someone please post some examples of:

Dim MyObj As Object 'why might they create their own object (and I don't mean just for late binding purposes).

Classes and hierarchies, such as parent / child relationships

I have tried reading Ramblings by Bruce McPherson:

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]http://ramblings.mcpher.com/

but find it difficult to understand everything, though I have grasped the basic concepts of classes, instatiation, etc.

Thanks


[/FONT]

 

[Jaafar Tribak]

Function MyFunc(somearg As Burger) As McDonalds

and then I start to panic as I believe this has been written by someone who has a formal training in programming because Burger and McDonalds (in my humble opinion) are classes.

Not necessarely just Classes. They could be any data structure such as Classes, Interfaces, UDTs and Enums.

 

[tiredofit]

Function MyFunc(somearg As Burger) As McDonalds

Not necessarely just Classes. They could be any data structure such as Classes, Interfaces, UDTs and Enums.

So even more confusing!

 

[RoryA]

You're already familiar with classes and hierarchies from the Excel object model - eg Workbooks and Worksheets.

 

[tiredofit]

You're already familiar with classes and hierarchies from the Excel object model - eg Workbooks and Worksheets.

Thanks but somehow I seem to have a mental block when reading other's code.

As I said, I have written basic classes myself, including situations when only a class will do, eg ensuring a query has completed (when extracting info from a sharepoint website) before the next step begins.

If someone wrote a dictionary of dictionaries in vba, is that advanced coding or convoluted?

 

[RoryA]

Depends on the situation; could be overkill, or entirely reasonable!