Microsoft Excel VBA Introduction
Mullan Training
Duration: 2 Days
Contact us
(£330 Price Per Person (excl VAT))
Detailed information
| Duration: | 2 Days |
|---|---|
| Price: | Contact us (£330 Price Per Person (excl VAT)) |
| Type: | Training |
| Method: | In a classroom |
| Prepares for: | 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. |
| Geared towards: | This 2 day Excel VBA 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. |
| Requirements: | A high proficiency of Microsoft Excel is essential, or completion of our 2 day Advanced MS Excel course |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Introduction
• What is a Macro
• Recording a Macro
• Relative References
• Running A Macro
• Running A Macro From The Macros Dialog Box
• Editing A Macro With Visual Basic
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
• Creating A Short-Cut Key To Run A Macro
Visual Basic Editor
• Objects
• Methods
• Properties
• Programming Tools
• The Menu Bar
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
• This Work Book
• What is a Macro
• Recording a Macro
• Relative References
• Running A Macro
• Running A Macro From The Macros Dialog Box
• Editing A Macro With Visual Basic
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
• Creating A Short-Cut Key To Run A Macro
Visual Basic Editor
• Objects
• Methods
• Properties
• Programming Tools
• The Menu Bar
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
• This Work Book
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- 1st Floor Blackstaff Studios, 8-10 Amelia Street, Belfast, BT2 7GS - BT2 7GS
Mullan Training
Mullan Training is a Northern Ireland based Computer Training Provider and has been providing high quality training to the public and private sectors for over 15 years.
Located at Blackstaff Studios (Amelia Street, Belfast) we occupy spacious fully air-conditioned training suites right in the heart of Belfast City Centre - Just opposite the Europa Hotel.
We offer an extensive range of public and closed courses including
• Microsoft Office
• Microsoft
• Adobe Creative Suite
• QuarkXpress
• Crystal Reports
• Sage
Meeting Your Needs
To ensure your training needs are met, we have a number of delivery types available. Please review below and if you have any queries do not hesitate to contact us.
Public Courses
• Our public courses are detailed on our public schedule
• The courses run from 9.30am - 4.30pm, and are open to individuals or groups
• Group rates apply
• These are run on scheduled dates at our premises
• Lunch Provided
Closed Courses
• To suit your training needs we can deliver for your group only
• We can customize content and duration to ensure you get maximum benefit of the course
• Where appropriate it is possible to use your own data, particularly useful for database, report writing and spreadsheet courses
• For web, image & video editing course you can bring your own material to work on
• Lunch optional
One-To-One
• Ad-hoc course covering specific topics within a single application
• Alternatively various topics within a number of applications can be covered
• Can be delivered on our premises or onsite - where we can also provide laptops, LCD projectors and flipchart at no extra charge.
• Lunch Provided
Onsite
• Use your own data, live if possible
• Tailored (customise course outlines to meet specific needs)
• Courses can be delivered at our training premises or onsite at your premises -where we can also provide laptops, LCD projectors and flipchart at no extra charge.
• Group rates apply
Located at Blackstaff Studios (Amelia Street, Belfast) we occupy spacious fully air-conditioned training suites right in the heart of Belfast City Centre - Just opposite the Europa Hotel.
We offer an extensive range of public and closed courses including
• Microsoft Office
• Microsoft
• Adobe Creative Suite
• QuarkXpress
• Crystal Reports
• Sage
Meeting Your Needs
To ensure your training needs are met, we have a number of delivery types available. Please review below and if you have any queries do not hesitate to contact us.
Public Courses
• Our public courses are detailed on our public schedule
• The courses run from 9.30am - 4.30pm, and are open to individuals or groups
• Group rates apply
• These are run on scheduled dates at our premises
• Lunch Provided
Closed Courses
• To suit your training needs we can deliver for your group only
• We can customize content and duration to ensure you get maximum benefit of the course
• Where appropriate it is possible to use your own data, particularly useful for database, report writing and spreadsheet courses
• For web, image & video editing course you can bring your own material to work on
• Lunch optional
One-To-One
• Ad-hoc course covering specific topics within a single application
• Alternatively various topics within a number of applications can be covered
• Can be delivered on our premises or onsite - where we can also provide laptops, LCD projectors and flipchart at no extra charge.
• Lunch Provided
Onsite
• Use your own data, live if possible
• Tailored (customise course outlines to meet specific needs)
• Courses can be delivered at our training premises or onsite at your premises -where we can also provide laptops, LCD projectors and flipchart at no extra charge.
• Group rates apply
