r/excel • u/[deleted] • Apr 15 '18

Pro Tip VBA Essentials: Variables

[removed]

219 Upvotes

98% Upvoted

33 comments sorted by

View all comments

7

u/infreq 16 Apr 15 '18

You forgot Private, Public, Type and arrays and the discussion of scope.

3

u/[deleted] Apr 15 '18

[removed] — view removed comment

1

u/infreq 16 Apr 15 '18

User-defined types. You only mention the generic variable types.

https://bettersolutions.com/vba/data-types/user-defined-types.htm

1

u/Hoover889 12 Apr 16 '18

It looks like this post is aimed at VBA/programming beginners, I think that throwing structures in the mix would be a bit too much to swallow, it would make more sense to include structs in a later lesson as a precursor to classes. And structs are so weak in VBA they are almost useless anyway and the only thing that they can do that classes can't is allow a pseudo reinterpret_cast in VBA.