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

  • Joomla! 2.5: An Essential Management System

    Joomla! 2.5: An Essential Management System

    SGD $45.00

    Course Description

    Joomla is a popular and highly functional content management system. Joomla is a mobile ready, responsive system that will adapt to user platforms and is extremely user friendly for both site users and site managers. In this VTC course, author Melanie Hedgespeth will show you how to install Joomla and work with the site from an administrative standpoint. From the administration side of Joomla you will learn how to handle users and permissions, increase Joomla functionality with extensions, change templates and most importantly how to keep your site secure and backed up.Keep your back covered with Joomla!- Learn how you can keep your page secure and backed up with Joomla- Know how Joomla can play a constructive part in maintaining your page - Learn how Joomla can prevent malicious acts on your page ​- Understand how Joomla's key functions can fend off attacks on your pagesThis course is SkillsFuture Credit Eligible.

    Read more...

  • Microsoft Office for Mac 2011

    Microsoft Office for Mac 2011

    SGD $45.00

    Course Description

    Office for Mac 2011 is a powerful update of the widely used productivity suite. Mac users now have access to a slew of updated features which are designed to simplify workflow while still maintaining the incredible strength of inter-application collaboration. This VTC course explores the 2011 update through a detail driven approach and with the help of practical examples. All of the major applications in Office are covered, along with several of the lesser profile utilities. Office may be constantly changing, but that doesn't mean you need to be left behind! Jump on board with Sam McGuire and get the very most out of the tools you use on a daily basis. 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.

    Read more...

  • FileMaker Pro 12: Advanced

    FileMaker Pro 12: Advanced

    SGD $63.00

    Course Description

    FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical ’how to’ course by FileMaker expert John Mark Osborne starts from advanced level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 features and techniques including: Ultimate Find, saving a found set of records for future retrieval, saving find criteria for future use, text parsing to create features, making new requests easier for users, parsing web form generated emails, five methods for deleting duplicates, recursive phone filter, creating preferences in a single-user and multi-user scenario, web-like back and forward buttons, conditional buttons, custom form letters, changing text attributes with scripts, script triggers and many more techniques with an emphasis on adaptive scripting and calculations. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning. Discover how data can be managed efficiently. - Find out how you can manage your database- Learn ways to fully utilize your data's potential - Know how queries can be implemented to run the data better - Understand an effective solution to optimize your database's productivity 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.