Dear Excel/VBA user and programmer, I am looking for a training in Excel VBA starting from Basic to Advanced level. Currently I do use VBA but with some limited knowledge, however I think I have gained a good experience of Excel. I am currently based in Bangalore so if someone can suggest something based on this location then it would be really helpful. I need this quite urgent as its being a long search for me and I think someone here would be able to guide me. Below is the course outline which I would like to get trained on. . Looking forward for some reply.
Thanks, Dibyendu Visual Basic for Applications Environment Visual Basic Editor and its options Component Management Shortcuts Environment Optimization Introduction to Procedural Programming Procedures: Functions and Sub-routines Data Types Control Flow If ...Then....Elseif....Else....Endif Case Do...Loop , While For... Next Exit Arrays and Loops Strings Visual Basic VBA and Sheet Data Exchange (Cells, Range Methods) Getting and Printing Data from Users (InputBox, MsgBox) Variable Declaration Scope and LifeTime of Variables and Objects Operators and Their Priorities Modules Options Creating Worksheet Functions Objects, Classes, Methods and Properties Locking Project for Viewing Debugging Run Time, Design Time, and Break Mode Brakes and Watches Local Window Immediate Window Call Stack Error Handling Errors Types On Error GoTo On Error Resume Next Excel Model Object Application Object Workbook Object and Workbooks Collection Worksheet Object and Worksheets Collection ThisWorkbook, ActiveWorkbook, ActiveCell, .... Selection Object Range Collection Cells Collection Using Status Bar Screen Updating and Optimizing Timer and Time Measuring Events Handling in VBA VBA Forms Creating and Using Forms Invoking Forms in VBA Code Using VBA Forms in Worksheet Excel Object Model Workbook and worksheet object Workbooks and worksheets collections Range object's properties and methods Current Region object Chart object Statusbar Timer List object Events Events with application object Arrays Dynamic arrays Arrays optimization Multidimensional arrays Arrays and objects Object Oriented Programming (OOP) Classes and objects Set and Let statements Creating new objects Creating new classes Destroying objects Methods and properties Default property and method Classes and error handling Collection Creating and using collections Adding and remove elements Using index and key Typed collection* Procedures, parameters, variables Passing parameters by reference and by value (ByRef i byVal) Optional and default parameters Passing an array of arguments to a procedure Using enumerations User-defined Type Differences and use cases of Null, Nothing, empty string "", Empty, 0 Implicit and explicit conversions Dealing with files Reading text files Using CSV files Writing cross-application code Using Excel Object Model in other applications Add-ins Creating simple add-in Creating menu and toolbar in add-in Deployment and securing add-ins Using external libraries Using external data sources (Access, Oracle, etc.) Using ADO Data providers Configuring ODBC sources --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
