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

  • Google Apps for Business

    Google Apps for Business

    SGD $45.00

    Course Description

    Whether you are a business owner, personal google apps user, or google apps administrator, this VTC Google Apps for Business course has been designed to take you from a beginner to an advanced user in no time at all. It will cover each Google App in detail including lots of great functionality that will impress your friends, family, and co-workers. You can easily jump to sections of the course that are relevant to you, including Google Apps Setup, Gmail, Contacts, Tasks, Calendar, Groups, and Drive. Drive is really where cloud computing comes to life; Documents, Spreadsheets, Presentations, and Forms each get their own chapter because their functionality is so rich. This phenomenal course is packed to brim with goodness and draws upon Andrew Martin's many years of experience working with and teaching Google Apps. Get ready to transform your way of working while you bring collaboration and efficiency to your project or company. TKnow all about Google's Apps with this course!- Learn about the different applications in Google - Understand how the different applications function- Learn about the features and functions of Google Apps - Know how to make full use out of the features 

    Read more...

  • MySQL Fundamentals

    MySQL Fundamentals

    SGD $79.00

    Course Description

    If you're new to web development, MySQL is the most popular database technology out there. This free technology is used to create the majority of database dependent websites (which most are). This course will start at the very beginning, with lessons on what MySQL is and how it works, to installing MySQL, then moving on to all the basic skills you'll need to use MySQL in the real world. You will also learn the popular new MySQLi framework. MySQLi is the next generation of MySQL, and if you know this now you will be ahead of the competition for a long time to come. Master MySQL and manage your own web database - Know how to manage your database with MySQL  - Learn ways to utilize your data for productivity  - Know more about MySQL and its advantages  - Learn how to improve your database system This course is SkillsFuture Credit Eligible.

    Read more...

  • Learn about Digital Audio with Steinberg Cubase 6

    Learn about Digital Audio with Steinberg Cubase 6

    SGD $49.00

    Course Description

    Steinberg's Cubase 6 is the latest update to the extremely popular professional digital audio workstation music software. In this course, author Mark Struthers will demonstrate how to make initial input and output connections to the program from the soundcard before examining routing in more detail. Additionally, insert and group effects are explored to help show how to enhance recorded audio tracks. Mark will walk you through the many-featured project window before showing you how to create and save your own project. Within the Cubase workflow, important terms such as clips, events, and parts are explained along with the distinction between lanes and tracks. Mark also covers insert and send effects, quantization, time stretch, and the Media Bay. Cubase comes equipped with VST instruments and, in particular, Groove Agent One and Halion Sonic SE are explored before working through the concepts behind a final mix and export to a finished audio track. Be able to produce music recording, arranging and editing with Steinberg. - Learn how to work with audio files using Steinberg- Know how Steinberg works as an audio editing software- Enable yourself to be able to produce your own music with Steinberg - Learn about the different techniques used in Steinberg to achieve quality audioThis 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.