|
This one day course can be booked according to our
course
schedule, or alternatively you can book a
trainer to visit you.
Contact us for more details! Please note we
can tailor this course to suit your needs, for
example we can include Access VBA, Word VBA etc.
We can hold this course onsite at your premises or
we can source a suitable meeting room.
Course objectives:
By the end of this course you should be confident to
create procedures for controlling the behaviour and
appearance of an Excel spreadsheet, create
procedures that run in response to specific events,
create user forms to accept or display data,
validate the data entry in user forms, and debug and
handle errors in code.
Prerequisites:
You should be an advanced user of Excel and ideally
have attended Intermediate and Advanced level
courses before this course.
Course contents
VBA terminology
Programming basics
Using loops
USER FORMS
-
Creating
a dialog box (user form)
-
Displaying a dialog box
-
Using
text boxes and labels
-
Using
command buttons
-
Using
combo and list boxes
Error
handling
-
Identifying compile-time, run-time and logical
errors in code
-
Use the debugging tools
-
Write error handling code to trap errors
Register
for our newsletter to receive details of current
special offers!

Providing training throughout England and Wales
including:
Excel VBA, Access VBA, VBA training, VBA course,
VBA training provider, VBA training provider
Bristol, Bath, Dorset, South West, Devon, Cornwall,
Somerset, Gloucestershire, London and many more
|