VBA Excel 2016 Lesson 8 - Select Case statement

Channel:
Australia Magic Monk
Subscribers:
65,900
Published on ● Video Link: https://www.youtube.com/watch?v=3bleEqcYyXY


Duration: 7:03
744 views
7

In this lesson we experiment with changing our If Statement to a Select Case statement, reducing the number of times the same code is typed and thus makes our code more efficient.



Other Videos By Magic Monk


2018-03-03Why Maths is useful in Fortnite - Get your weapon before others!!
2018-02-23Beginner Fortnite tutorial 1 - acquire materials & building structures
2018-02-08VBA Excel 2016 Lesson 10 - Variables, join concatenate Strings
2018-02-05VBA Excel 2016 Lesson 9 - For Next statement, Cells() property
2018-02-03Javascript games programming using Phaser in Dreamweaver lesson 12 - Looped intro animation
2018-02-02Javascript games programming using Phaser in Dreamweaver lesson 11 - Playing Sound
2018-02-01Javascript games programming using Phaser in Dreamweaver lesson 10 - High Scores
2018-01-31AngularJS lesson 4 - linking inputboxes and dropdowns to multidimensional JSON array
2018-01-29AngularJS lesson 3 - Modules and Controllers
2018-01-28Javascript games programming using Phaser in Dreamweaver lesson 9 - Changing States
2018-01-26VBA Excel 2016 Lesson 8 - Select Case statement
2018-01-24VBA Excel 2016 Lesson 6 - If then Else statement
2018-01-23Microsoft Excel Lesson - Pivot Tables
2018-01-18AngularJS lesson 2 - using expressions in HTML tags, ng-model directive, JSON objects
2018-01-16AngularJS Lesson 1 - Set up Visual Studio, ng-app and ng-init Directives, Expressions
2018-01-16VBA Excel 2016 Lesson 7 - Elseif clause, With statement
2018-01-12Make a mobile responsive website with Bootstrap lesson 10 - Vertical and Horizontal Forms.
2018-01-09Make a mobile responsive website with Bootstrap lesson 9 - Inline form
2018-01-05Make a mobile responsive website with Bootstrap lesson 8 - Carousel
2018-01-02Make a mobile responsive website with Bootstrap lesson 7 - Popovers
2018-01-01Capstan Style Tap Dripping Water Fix


Tags:
select case excel vba