|
Obiz Pakistan (Pvt.) Ltd. Corporate Trainers & Consultants ……….INDUCING STRENGTH
|
 |
|
|
|
| ||||
|
|
Working with Excel Macros Instructors: Asif Akber, Saeed Akhtar Duration: 12 Hours and 20 Hours modules Introduction What Is A Macro? How Much Useful It Is? The Macro Recorder Visual Basic and VBA What Is VBA? Where Does VBA Come From? Should I Learn VBA Or VB? The Visual Basic Editor The VbaProject Window The Properties Window (Sheet1) The Properties Window (Module1) Modifying Macros Modifying a Macro Creating Macros with VBA for Excel Testing Macros The Events Excel VBA Controls Command Buttons Drop-Down Lists VBA Command Buttons Forms and Controls Security and Protection Protecting the Code Protecting the Workbook Hiding Worksheets Working with Cells Working with Worksheets ScreenUpdating CutCopyMode Quit Goto Functions Existing Excel Functions New Excel Functions End Function VBA Functions Do..Loop The Variables Excel VBA Code for Forms and Controls Excel Macro Tips No Macros No Viruses A Very Hidden Sheet Message Boxes It Must Be Triggered Run a Macro Step By Step and See It At Work In Excel Don't Bother the User Save It without Bothering Me The Visual Basic Editor Filters On Or Off Key Activated Macros |
|
For further information contact: info@obizpakistan.com B5, Gulistan Khan House, 82 East, 'F' Block, Blue Area, Fazl-ul-Haq Road, Islamabad, (near Rahat Bakery) Phone: (92) (51) 2275804; Fax: (92) (51) 2802440; Cell Contact: Hasan Akber, Program Manager, 0(092)3335769121 |
