how many classes in vba

[lezawang]

Hi
How many classes in excel vba? is there any site/doc that lists all these classes.
Thank you.

 

[RileyC]

Not sure amount of classes as I'm on a mobile device but a quick Google search gave a reference guide at https://docs.microsoft.com/en-us/office/vba/api/overview/language-reference

Personally I create classes that are based on what I need, it's not hard and can run faster than the ones that are pre-programmed for VBA as you can remove unecessary code.

 

[lezawang]

Wow, that is very new to me, can you create you own classes? How? Would appreciate any hint.
Thank you very much.

 

[MARK858]

How? Would appreciate any hint

You really could Google this type of question yourself

https://excelmacromastery.com/vba-class-modules/

http://www.cpearson.com/excel/classes.aspx

https://analystcave.com/vba-vba-class-tutorial/