The VBA Fundamentals for Financial Professionals course broadens and deepens the skills and knowledge the participants have already gained by using Excel for analysis and modeling. The course uses a modular approach for introducing the basic concepts of code and interface controls.
VBA Introduction – what you need to know in order to start using VBA • How to use the Visual Basic Editor • Use Code Window and customize the working environment • Excel Macro recorder - as an example on how code is created • An overview of objects, collections, properties, and methods • A case study VBA Programing Fundamentals (Writing Code) • VBA Language Elements - Overview • Elements and structure of code • Variables, Data Types, Constants • Arithmetical and Logical Operators • Controlling Code Execution • If-Then – code; uses and examples • Loops – code; uses and examples Building User Interfaces • Message Boxes • Buttons • Combo Box
To receive CFA member pricing please contact Dawn Wong dawn.wong@cfatoronto.ca or 416-366-5755 x226
This event is currently only available for users in the following groups: everyone.
To register for this event, please login above.
The information, analysis and opinions expressed in the webinars, podcasts and/or congress presentations are solely those of the presenter/author, are not reviewed by the Institute as to content or accuracy, and are not endorsed by CBV Institute or any of its Members.