Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


Microsoft Visual Basic for Applications (VBA)


  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course
  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course
  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course
  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course
  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course
  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course

Course Description

The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed. However, Microsoft provides an interface in which the user can create customized processing. The language used for this customized processing is based on a computer programming language called Visual Basic. The Microsoft programming environment, called Visual Basic for Applications, has a special format and syntax that must be followed in order for the computer to properly perform the work. This VTC course describes the reserved keywords, structures, and language aspects that a user would need to know in order to create customized processing for Microsoft Office applications. Work Files are included.

Find out more about Microsoft's productivity tools!

- Learn and understand the purpose of Microsoft's tools
- Know more about the functionality and features of each application
- Learn about functions that you never knew existed in Microsoft's tools
- Be fluent and an efficient user in Microsoft tools by the end of this course

This course is SkillsFuture Credit Eligible.


Course Objectives

1. Know and understand the basics of Microsoft Visual 
2. Know how to navigate the interface and tools pane 
3. Understand about Data Variables and Loops
4. Understand about Macros, VBA Expressions and Dialog boxes 
5. Knows about Conditional Processing 
7. Know how to test your work 


Related Courses

  • Avid Pro Tools 11: Know how to work with audio

    Avid Pro Tools 11: Know how to work with audio

    SGD $45.00

    Course Description

    Avid Pro Tools 11 is the standard when it comes to audio recording and mixing. Version 11 brings additional features and power to the audio production process. This VTC course explores these features along with the basics of operation. Author Sam McGuire demonstrates how to use this software in a variety of situations using provided work files. This course is an excellent resource for anyone who wants to learn how to use Pro Tools. Learn how to work with audio files using Avid Pro Tools. - Know how Avid Pro Tools handles audio - Learn how to edit your own audio files with Avid Pro Tools- Discover the potential of Avid Pro Tools with your audio files- Master audio editing with all the right tools and techniques in Avid Pro ToolsThis course is SkillsFuture Credit Eligible.

    Read more...

  • Camtasia Studio 7 and Snagit 10: Know how to work with audio

    Camtasia Studio 7 and Snagit 10: Know how to work with audio

    SGD $49.00

    Course Description

    This VTC course introduces you to Techsmith's two programs: Camtasia Studio 7 and Snagit 10. Author Mark Struthers will first demonstrate how to use Camtasia Studio before moving on to Snagit so that you understand how both programs complement each other when creating screen recording videos. Additionally, you will see two mini Camtasia projects that illustrate how you can create educational resources for the classroom. Create your masterpiece with Camtasia and Snagit. - Learn the different tools and techniques to produce a screen recording videos- Know how to utilize both softwares in any projects - Discover the secrets of producing a quality video- Learn the ropes of creating your own master piece with this course This course is SkillsFuture Credit Eligible.

    Read more...

  • Google Docs & More: Maximize your online collaboration with Google

    Google Docs & More: Maximize your online collaboration with Google

    SGD $99.00

    Course Description

    Use Google Docs to create documents for collaboration with others online. Google™ Docs has numerous tools for editing and formatting your documents. In this online training series, we’ll learn to format text, add images, links, and comments. We’ll also explore tools for replacing words, checking spelling, and adding a table of contents. Make it easy to share your documents online and collaborate with others. We’ll explore some sharing options through email, invite individuals to collaborate, and manage our list of editors. You’ll also learn to assign ownership of a document, and set downloading options.Make it easy to share your documents online and collaborate with others!- Learn and understand the basics of Google Docs and their features- Be updated on the new kind of Web mail - Learn techniques of Goggle's spreadsheet functions - Know how Google™ Forms can bring productivity and results This course is SkillsFuture Credit Eligible.

    Read more...


Content

Introduction

+

What VBA Is

What This Course Is About

VBA vs. Visual Basic

Using the VBA Editor

Data and Variables

+

Data Types

Storage and Data Sizes

Declaring Variables

Variable Names

Putting Values in Variables

Creating Constants

String Variables

Handy String Functions

What an Array Is

Creating Arrays

Resizing Arrays

2-Dimensional Arrays

Sample Variables

Using Macros

+

Macro Recording

Recording a Macro

Running a Macro

Editing a Macro

Help in VBA

Application Object

VBA Expressions

Preview Available

+

Simple Arithmetic Operators

Advanced Arithmetic Operators

Comparison Operators

Logical Operators

Order of Operations

Mathematical Expressions

Using Functions in Formulas

Mathematical Functions

Conversion Functions

String Functions

Finding Words in Strings

Replacing and Comparing Strings

Sample Expressions

Working with Dates

Date Functions

Dialog Boxes

+

User Interaction

Using Message Boxes

Format Options

Results of Message Boxes

Using Input Boxes

Functions and Procedures

+

Creating a Subroutine

Understanding Parameters

Parameter Passing

Function vs Procedure

Return Statement

Sample Function AVE

Arrays as Parameters

Conditional Processing

+

What Conditional Processing Is

IF Block

Complex Conditions

Nested IFs and Elseif

Using IF in Coin Toss

Sample Function MIN

Multiple Outcomes

SELECT Block

Multiple CASE Statements

Conditional Functions

Loops

+

Parts of a Loop

Infinite Loops

DO WHILE Loop

DO UNTIL Loop

FOR Loops

Running Arrays

Update AVE Function

Sample Array Sort

Sample Swap Routine

Tracing FOR Loops

Step Value in For Loops

EXIT Statement

Testing Your Work

+

The Debug Environment

Seeing Values

Stepping Through Code

Breakpoints

Finding and Fixing Errors

Conclusion

+
Resource Files

What We Learned

Planning for your VBA Code

Credits

+

About the Author

SkillsFuture Credit Eligible
SGD $45.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.