Mastering The Select Case Statement In Excel VBA | Full Tutorial

In this week’s training, I will share with you a complete masterclass on how to use the powerful Select Case Statement in Excel VBA, along with real-world samples and a complete and free workbook download

⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:

EXCEL COURSES:

EXCEL PRODUCTS:

Timestamps:
0:00 – Introduction
3:26 – Basic Select Case Statement
6:32 – Multiple Condition Value
8:08 – Multiple Condition String
9:22 – Select Case With A Range Of Data
10:40 – Select Case With Multiple Wildcards
17:45 – Send Email Select Case

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin

#ExcelForFreelancers #selectcasesatement #Excelvba #VBAtutorial #SelectCase #ExcelSelectCase

[SM-tzhc]

I'm still speechless at what you do. you are a true master❤❤❤😮😮😮😮😮😮😮

[peterjames]

Excellent training Randy, looking forward to the next one

[guillermohernandez-trejo]

Great your videos and great your explanations, Thanks Randy from North Carolina.

[carloscrespo-riera]

Randy, again, thanks so much for sharing your knowledge and taking the time to educate all of us.

[klebersonmoreira]

Sensacional, obrigado por compartilhar seus conhecimentos. Mestre, como carregar dados do Treeview no Listview?

[mkhanapathan]

I have been programming for a long time but learning is a never ending journey and I always enjoy watching your videos aa one can learn something new and/or ways of doing something in totally different manner - often more efficiently. Thank you


p. s. in your bakery manager system, it would be good to see batch allocation for stock which can show your users how to track multiple batch stocks (stock from one batch utilised in multiple product makeup and multiple deliveries in one product i.e. limited stock available from one delivery for product makeup needing partial stock from another delivery to be allocated) and see in the BOM multiple batch numbers from which stock has been used along with the allocated stock from each.

[nilzomanjate]

Amazing! Thanks very much, great video, it will save tons of working hours. ❤

[robertbateman]

Select Case is great if you have several "ELSEIFs" with multiple conditions. As always, another great tutorial. Thanks!

[williamcrockett]

He takes this from "Axis Of Awesome, for chords song"

[vinerguigreffou]

hello sir first of all thank you for everything but I would like you to create an excel application for creating entry tickets for events and also that it is possible to scan the ticket with the software at the entrance to avoid fraud