Course not currently available
Visual Basic for Applications (VBA) in Excel - Introduction to programming Training Course
Course
In Southampton ()
Description
-
Type
Course
It is an introduction to procedural programming in VBA. Training allows you to gain a strong foundation for further learning and VBA environment.
After the course you can:
Record and edit the macro as required,
Write procedures using data from the sheet,
Create your own functions
Handle the event (opening worksheet cell update etc) by means of the handler,
Create form
About this course
Ability to work with a spreadsheet, basic knowledge (references, ranges, sheets, ...). Knowledge is no required to create new macros or VBA code. The course is a gentle introduction to programming problems and automate tasks in Excel.
Reviews
Subjects
- Excel
- Visual Basic training
- Visual Basic
- Programming
- MS Excel
Course programme
- Recording and editing macros
- Assigning macros to forms, toolbars, keyboard shortcuts
- Visual Basic Editor and its options
- Management components
- Keyboard Shortcuts
- Optimizing the environment
- Procedures: Function Sub
- Data types
- The if statement ... then ... elseif ... else ... end if
- Case statement
- Loops for ... loop while, until
- Loop for ... next
- Instructions loop break (exit)
- Array processing
- Combining quoted strings (concatenation)
- Conversion to other types of (implicit and explicit)
- Features processing quoted strings
- Download and upload data to a spreadsheet (Cells, Range)
- Download and upload data to the user (InputBox, MsgBox)
- The declaration of variables
- The extent and lifetime of variables
- Operators and their priorities
- Options modules
- Create your own functions and use them in a sheet
- Objects, classes, methods and properties
- Securing code
- Security code tampering and preview
- Processing step
- Locals window
- Immediate window
- Traps - Watches
- Call Stack
- Types of errors and ways to avoid
- Capturing and handling run-time errors
- Structures: On Error Resume Next, On Error GoTo
- The Application Object
- Workbook object and a collection of Workbooks
- Worksheet Object and Collection Worksheets
- Objects ThisWorkbook, ActiveWorkbook, ActiveCell
- Object Selection
- Collection Range
- Object Cells
- Display data on the status bar
- Optimization using ScreenUpdating
- The time measurement by the method Timer
- What is an event?
- Responding to an event and create an event handler
- Triggering Event Handlers
- Service frequently occurring events
- Create your own forms
- Calling a form from code
- Use the forms in the sheet
Additional information
Visual Basic for Applications (VBA) in Excel - Introduction to programming Training Course