Training Course:Excel VBA advancedSchool/Trainer:Mullan Training
Belfast, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Course Description:
'' Brief Overview of Previous Course
§ Consolidate areas of the Previous Course(s)
Excel Objects
§ Calling Methods
§ Passing Arguments
§ Singular Objects & Collections Of Objects
Variables
§ Dimensioning A Variable
§ Object Variables
Using Visual Basic Functions
§ Using A Set Statement
Building Formulae Control Structures
§ Select Case Decision Structures
§ Case Else
§ Comparison Operators With Select Case Structure
§ While...Wend Statement
Event Handling
§ VBA Editing & Debugging
§ Auto Macros
§ Error Handling
Running Code
§ Run Mode And Design Mode
§ Running Code From The Development Environment
§ Running Code From The Host Application
Storing Information
§ The Windows Registry
§ Settings Files
§ WritePrivateProfileString
Debugging and Error Trapping
§ Errors
§ Break Mode
§ Instant Watch
§ Stepping
§ Error Handling
§ Error Handling Example
Worksheet and Workbook Events
§ Worksheet Object Events
Validations
§ Validating The User Inputs
§ When To Apply Validation, Control Events
Parsing
§ Parsing Control Values Back To A Spreadsheet
§ Parsing Range Values To The Userform Controls
Controls
§ Creating Template Controls
§ Using The Refedit Control
§ Finding The Active Control
§ Creating Controls At Runtime
...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.mullantraining.com/
Phone:+ 44 (0) 28 9032 2228
School Address/Venue(s):
Mullan Training
Ist Floor, Blackstaff Studios
Blackstaff Square
8-10 Amelia St
Belfast
BT2 7GS
United Kingdom
Jobs & Resumes: Belfast
Houses & Roommates: Belfast
Travel Agencies: Belfast
Search other schools for Excel VBA advanced training resources.
Other training courses offered by Mullan Training:
Access Advanced
Access VBA
Access
Excel - Advanced
Excel
Excel VBA
Microsoft Office 2007
Outlook
Powerpoint - Advanced
Powerpoint
Word - Advanced
Word
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting. |
|
| 
