Excel VBA Introduction Training Course

By: NobleProg (UK) Limited  24/03/2011
Keywords: computer training, IT consultancy, computer education

Recording and Modifying Macros

Assigning Macros to Toolbar, Buttons, Shortcut key

Visual Basic Editor and its options

Component Management


Environment Optimization

Procedures: Functions and Sub-routines

Data Types

If ...Then....Elseif....Else....Endif


Do...Loop , While

For... Next


Arrays and Loops


VBA and Sheet Data Exchange (Cells, Range Methods)

Getting and Printing Data from Users (InputBox, MsgBox)

Variable Declaration

Scope and LifeTime of Variables and Objects

Operators and Their Priorities

Modules Options

Creating Worksheet Functions

Objects, Classes, Methods and Properties

Locking Project for Viewing

Run Time, Design Time, and Break Mode

Brakes and Watches

Local Window

Immediate Window

Call Stack

Errors Types

On Error GoTo

On Error Resume Next

Application Object

Workbook Object and Workbooks Collection

Worksheet Object and Worksheets Collection

ThisWorkbook, ActiveWorkbook, ActiveCell, ....

Selection Object

Range Collection

Cells Collection

Using Status Bar

Screen Updating and Optimizing

Timer and Time Measuring

Creating and Using Forms

Invoking Forms in VBA Code

Using VBA Forms in Worksheet

Keywords: computer education, computer training, IT consultancy, it consultants, it training

Contact NobleProg (UK) Limited


Print this page

Other products and services from NobleProg (UK) Limited


JMeter Fundamentals Training Course

This course covers the creation and implementation of functional and unit testing with Apache JMeter, the free application testing software from The Apache Software Foundation. The purpose of the course is to allow organisations to completely automate their various testing requirements, saving time, money and helping to minimise the risk of human error in testing. The programme explores the concepts of designing and creating test plans for real-world web applications using Apache J


Strategic Planning in Practice Training Course

This training course has been created for investors, business owners, directors, managers, executives and analysts who need to develop strategic planning skills. It is not designed for academic purposes, but to start realizing your dreams today. This course focuses on strategic planning for technology-based businesses in which flexibility and constant learning is the most important thing. The main emphasis is corporate and investment strategy using current real-world examples. Each c


SQL Programming Training Course

This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of data differences between SQL dialects (Oracle, T-SQL, ANSI) practical skills for writing queries This SQL course deals with generic ANSI SQL. It can be used in a


MySQL Database Administration Training Course

MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties. The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your datab


Java Fundamentals Training Course

The course covers the basics of Java development. It introduces students to Java technology and teaches them basic Java syntax and concepts, leading to the creation of a simple program. Training goes through the essential concepts and features of the Java Programming Language, focusing on exceptions, basic input/output, concurrency, regular expressions, Java collections framework and the platform environment. The course finishes when all basic Java features have been explained and