Excel VBA Introduction Part 54.2 - The Switch Function
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-goul... By Andrew Gould Download files here https://www.wiseowl.co.uk/videos/exce... https://www.wiseowl.co.uk - The Switch function allows you to perform multiple logical tests in a single, succinct expression in VBA. For simple conditions, you can use Switch as an elegant replacement for long-winded Select Case statements. This video shows how the Switch function works, inluding how to use it to create a user-defined function to help separate a list of data into different sheets. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
Excel VBA Introduction Part 55.1 - Working with Dates
Excel VBA Introduction Part 54.1 - The IIf Function
Try The SWITCH Function Instead of IF Statements
Excel VBA Introduction Part 53.2 - Splitting Strings
Stop Using IF Statements! Use This VBA Trick Instead
Trump Gets Booed & Falls Asleep During NBA Finals, Claims War is Almost Over & Goodbye Spencer Pratt
Excel VBA Introduction Part 18 - Creating Functions
Excel SWITCH Function, is it really as good as they say? You might be surprised!
Excel VBA Introduction Part 43.2 - ByRef and ByVal (When to use Parentheses)
Do You Need to SWITCH from Excel VBA Macros to Office Scripts?
Excel VBA Introduction Part 53.6 - The Asc and Chr Functions
The Match That Made Brazilians Hate Germany
Something is jamming GPS over Europe. Here's what we found
How to get the Last Row in VBA(The Right Way!)
The French Do Not Care About Work
Excel VBA Introduction Part 20.1 - Event Procedures
Sarah Paine - Why Russia and China can't escape geography
Excel VBA Macro: Autofilter And Copy to New Workbook (Dynamic Range)
Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo)
