User Defined Types (Structs) in VBA

*** My VBA Troubleshooter course $10 coupon http://bit.ly/VBA_TS_10 ***

The spreadsheet for this video can be downloaded from Mega using the link below:
http://bit.ly/Structs_xlsb

User Defined Types (Structs) in VBA

Video description
----------------------------
The goal of my Excel VBA tutorials are to take you from a beginner level to a confident Excel VBA developer and programmer as quickly as possible. The best way to do this is to help you UNDERSTAND Excel VBA code and how to build robust Excel spreadsheets.

User Defined Types (Structs) in VBA are somewhere between a set of related constants and a class: they can contain member data of various variable types but all of this data is public (any part of your program can view and edit the member data). In addition they cannot contain methods (functions). However, they can provide a useful data structure for holding related information in a structured way.


In this free beginner level Excel tutorial we use Microsoft Excel 2016 and you will learn:
1. The Syntax for creating a user defined type (Struct) in VBA code;
2. How you can initialize or set the values for the member data of a VBA Struct;
3. How to declare a User Defined Type in VBA using the Dim keyword;
4. How you can access the values within the member data of a user defined type using the dot operator (and the intellisense dropdown);

We also review how to build an enumeration using MZ-Tools code snippets, how to include an enumeration in a user defined type and how to build a Select ... Case block around an enumeration using the MZ-Tools select-case tool.

The video uses Excel 2016 but the same steps are used for Excel 2010, Excel 2013 and equivalent versions of Microsoft Access.

If you enjoyed this short tutorial then please add a comment, start a discussion, "Like", "Favourite" or "Share" the tutorial and subscribe to my channel.


Channel Links and Playlists
----------------------------
https://www.youtube.com/channel/UCY-6DstZI7EDeIP2rgKhTAQ?sub_confirmation=1

Understanding VBA Code playlist: https://www.youtube.com/watch?v=qfqcIZWumsE&list=PLPTvzeeVEaJeghzj3tame6s1-QT6QRxGc
Official Channel Series: https://www.youtube.com/watch?v=l1fV227ugd8&list=PLPTvzeeVEaJdR1f8AEzKDXb9TTMcnQHL7

Other Useful Links
----------------------------
A full list of my Udemy courses can be found on my Udemy profile page: https://www.udemy.com/user/paulmorrissey4/

My Excel VBA Troubleshooter course is here: https://www.udemy.com/become-a-vba-troubleshooter

WiseOwl provides a lot of very good VBA tutorials: https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw

Sali Kaceli provides a lot of Excel and VBA related tutorials also: https://www.youtube.com/user/skaceli

Chip Pearson has a lot of VBA content - if Chip says you should do something ... you probably should: http://www.cpearson.com/


Thanks for watching!

Paul.