Understanding VBA Code: Enumerations Part 5 (Select Case)

*********************************
*********************************

Understanding VBA Code: Enumerations Part 5 (Select Case)

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.

A common task when using enumerations is to build a Select Case block using an enumerated variable. A quick way of doing this is to use MZ-Tools for VBA to auto-generate the shape of the Select Case for your.

In this free beginner level Excel tutorial we use Microsoft Excel 2016 and you will learn:
1. How to use MZ-Tools Select Case for Enums tool to build a Select Case in VBA to fit a given enumerated variable;

2. How to use the MZ-Tools Message box assistant to quickly build the code needed for a message box in VBA - no more forgetting how to get a given combination of buttons and settings!;

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
----------------------------

Other Useful Links
----------------------------

Thanks for watching!

Paul.