|
Provided by: Mullan Training VB ExcelComputer |
 |
This 2 day course is suitable for Advanced users of Microsoft Excel responsible for very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data.
PREREQUISITES
A high proficiency of Microsoft Excel is essential, or completion of our 2 day Adavnced MS Excel course.
BENEFITS
At the end of the course the delegate will have covered the fundamentals of VBA, including:
working with procedures and functions
understanding objects
using expressions, variables and intrinsic functions.
mastering how to control program execution
working with forms and controls
working with the PivotTable object.
debugging code & handling errors to ensure minimal downtime while building and effecting the program.
COURSE CONTENT
Introduction
What is a Macro
Recording a Macro
Running a Macro
Relative References
Assigning Macros to Buttons and Objects
Assigning a Macro to a Button on a Sheet
Assigning a Macro to a Drawn Object on a Sheet
Assigning a Macro to a Button on a Toolbar
Editing Macros
The Visual Basic Editor
The Project Explorer
The Code Window
Procedures
Inserting Comments
Printing a Visual Basic Module
The Range Object
The Cells Property
The Range Property
Flexible Ranges
Range Contents
Workbooks and Sheets
Activating a Workbook
Activating a Worksheet
ThisWorkBook
Objects, Properties and Methods
Controlling Objects with their Properties
Performing Actions with Methods
Performing Multiple Actions on an Object
Variables and Constants
Variables
Data Types
Constants
Control Structures
Conditional Control Structures
Looping Control Structures
Non-Structured Statements
Subprocedures
Controls, Dialogue Boxes and Forms
Built-In Dialogue Boxes
Predefined Dialogue Boxes
Custom Forms
Worksheet Forms
User-Defined Forms
Adding Form Controls
Form Control Properties
Control and Dialogue Box Events
Displaying and Dismissing a User Form
Handling Form Controls
Storing Information
The Windows Registry
Settings Files
WritePrivateProfileString
Toolbars and Display
About Toolbars and Menus
Customised Toolbars
Display
Debugging and Error Trapping
Break Mode
Instant Watch
Stepping
Error Handling
Error Handling Example
Worksheet and Workbook Events
Worksheet Object Events
Function Procedures
User-Defined Functions
LOCATIONS
Courses can be delivered at our offices in Belfast city centre (opposite the Europa Hotel) or in your own workplace (where we can provide 8 laptops, projector & flipcharts).
ADDITIONAL INFORMATION
If you would like more information please do not hesitate to contact us.
For a course outline visit our website
www.mullantraining.com
or email us at
info@mullantraining.com
or telephone
0289032 2228
PREREQUISITES
A high proficiency of Microsoft Excel is essential, or completion of our 2 day Adavnced MS Excel course.
BENEFITS
At the end of the course the delegate will have covered the fundamentals of VBA, including:
working with procedures and functions
understanding objects
using expressions, variables and intrinsic functions.
mastering how to control program execution
working with forms and controls
working with the PivotTable object.
debugging code & handling errors to ensure minimal downtime while building and effecting the program.
COURSE CONTENT
Introduction
What is a Macro
Recording a Macro
Running a Macro
Relative References
Assigning Macros to Buttons and Objects
Assigning a Macro to a Button on a Sheet
Assigning a Macro to a Drawn Object on a Sheet
Assigning a Macro to a Button on a Toolbar
Editing Macros
The Visual Basic Editor
The Project Explorer
The Code Window
Procedures
Inserting Comments
Printing a Visual Basic Module
The Range Object
The Cells Property
The Range Property
Flexible Ranges
Range Contents
Workbooks and Sheets
Activating a Workbook
Activating a Worksheet
ThisWorkBook
Objects, Properties and Methods
Controlling Objects with their Properties
Performing Actions with Methods
Performing Multiple Actions on an Object
Variables and Constants
Variables
Data Types
Constants
Control Structures
Conditional Control Structures
Looping Control Structures
Non-Structured Statements
Subprocedures
Controls, Dialogue Boxes and Forms
Built-In Dialogue Boxes
Predefined Dialogue Boxes
Custom Forms
Worksheet Forms
User-Defined Forms
Adding Form Controls
Form Control Properties
Control and Dialogue Box Events
Displaying and Dismissing a User Form
Handling Form Controls
Storing Information
The Windows Registry
Settings Files
WritePrivateProfileString
Toolbars and Display
About Toolbars and Menus
Customised Toolbars
Display
Debugging and Error Trapping
Break Mode
Instant Watch
Stepping
Error Handling
Error Handling Example
Worksheet and Workbook Events
Worksheet Object Events
Function Procedures
User-Defined Functions
LOCATIONS
Courses can be delivered at our offices in Belfast city centre (opposite the Europa Hotel) or in your own workplace (where we can provide 8 laptops, projector & flipcharts).
ADDITIONAL INFORMATION
If you would like more information please do not hesitate to contact us.
For a course outline visit our website
www.mullantraining.com
or email us at
info@mullantraining.com
or telephone
0289032 2228
|
|
||||||||||||||
Training
Provided by Mullan Training
- P asked: how to add a video clip to an excel vba userform
VB Excel
--
About The Training Provider: Mullan Training
Mullan Training - Mullan Training are a computer training company in Belfast city centre.
We deliver high quality computer training in Belfast and throughout Northern Ireland.
We can deliver computer training courses in our training suites OR in your own offices. We are an authorised
Microsoft Office Specialist (MOS) Testing Centre so delegates can prepare for & sit exams with us.
Courses we deliver...
