Module 3: Writing Procedure for Selection Techniques and Looping

Current Status

Not Enrolled

Price

Closed

Get Started

This course is currently closed

In this course, you will learn how to write procedures for selection techniques and looping.

Specifically, you will learn how to use:

1. Variables, Data Types, Constants, Decision Structures, IF…THEN …ELSE Statements, and SELECT CASE.
2. Logical Operators.
3. Looping Constructs.
4. VBA’s Built in functions.

Take this course to learn more.

Happy Learning!

Course Content

Expand All

21. Common Built-In Functions

22. Introduction to VBA’s Built-In Function – message box and input functions

23. Message Box Function – An Introduction and Syntax

24. Message Box Functions – Example 1 – Alert message

25. Message Box Functions using two examples.

26. Built-In Functions: Input Box Functions 1 Quiz

Expand

Lesson Content

Built-In Functions: Message Box and Input Box Functions

27. Introduction to Built-In Functions – String Functions

28. Understanding String Function – InStr Function

29. Understanding String Function – InstrRev Function

30. A lesson on String Function – Left Function

31. Understand String Function – Right Function

32. How to use String Function – Mid Function

33. String Functions – LCase Function and UCase Function

34. String Function – Len Function and LTrim Function

35. String Functions – RTrim and The Trim Function

36. String Functions – Space 1 Quiz

Expand

Lesson Content

String Functions

37. Creating Sub and Function Procedures

38. Sub Procedures

39. Function Procedures 1 Quiz

Expand

Lesson Content

Creating Sub and Function Procedures

Module 3: Writing Procedure for Selection Techniques and Looping – Feedback

2 of 2

Module 3: Writing Procedure for Selection Techniques and Looping

Course Content

Course Navigation

Book a Demo

Download form