Excel VBA Introduction Part 14 - Select Case Statements

Автор: WiseOwlTutorials

Загружено: 2014-02-03

Просмотров: 112356

Описание:

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

https://www.wiseowl.co.uk - Select Case statements in VBA are similar to If statements in that they allow to test whether conditions are met and perform different actions based on the result. This video explains how to use Select Case statements in your code, including the various ways to phrase a logical test, how to separate numbers into bands, how to test for lists of values and how to create nested Select Case statements.

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

Excel VBA Introduction Part 14 - Select Case Statements

Доступные форматы для скачивания:

Скачать видео mp4

Информация по загрузке:

Скачать аудио mp3

Похожие видео

Excel VBA Introduction Part 15 - Do Until and Do While Loops

Excel VBA Introduction Part 15 - Do Until and Do While Loops

Excel VBA Introduction Part 35 - Class Modules

Excel VBA Introduction Part 35 - Class Modules

Excel VBA Introduction Part 16 - For Next Loops

Excel VBA Introduction Part 16 - For Next Loops

Ответы Мудрой Совы - Как ускорить вычисления в Excel VBA?

Ответы Мудрой Совы - Как ускорить вычисления в Excel VBA?

Power BI DAX Tutorial for Beginners (2025): Master DAX in ONE Course!

Power BI DAX Tutorial for Beginners (2025): Master DAX in ONE Course!

4 Hours Chopin for Studying, Concentration & Relaxation

4 Hours Chopin for Studying, Concentration & Relaxation

Кадырова госпитализировали и «еле откачали». Поздравление Путина о войне. Проблемы с банкоматами

Кадырова госпитализировали и «еле откачали». Поздравление Путина о войне. Проблемы с банкоматами

Excel VBA Introduction Part 15a - Find and FindNext

Excel VBA Introduction Part 15a - Find and FindNext

Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course

Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course

5 секретов Excel, о которых вы можете стыдиться, если не знали

5 секретов Excel, о которых вы можете стыдиться, если не знали

Excel VBA Introduction Part 26 - Constants and Enumerations (Const, Enum)

Excel VBA Introduction Part 26 - Constants and Enumerations (Const, Enum)

Excel VBA Introduction Part 8 - Variables

Excel VBA Introduction Part 8 - Variables

Excel VBA Introduction Part 20.1 - Event Procedures

Excel VBA Introduction Part 20.1 - Event Procedures

Excel VBA Advanced Tutorial

Excel VBA Advanced Tutorial

Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo)

Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo)

Алгоритмы на Python 3. Лекция №1

Алгоритмы на Python 3. Лекция №1

Excel VBA Introduction Part 2 - Writing Your First VBA Macro

Excel VBA Introduction Part 2 - Writing Your First VBA Macro

Excel VBA Introduction Part 9 - Object Variables

Excel VBA Introduction Part 9 - Object Variables

Excel VBA Introduction Part 29.1 - Creating Outlook Emails

Excel VBA Introduction Part 29.1 - Creating Outlook Emails

Excel VBA Introduction Part 22 - Files and Folders (FileSystemObjects)

Excel VBA Introduction Part 22 - Files and Folders (FileSystemObjects)