English | August 22, 2018 | ISBN: N/A | ASIN: B07GSBQZ3L | 103 pages | EPUB | 1.77 MB
Learn to automate Excel using VBA (Visual Basic for Applications)
VBA is a event driven programming language and you can program any actions that you would do manually in an Excel. You can automate Excel using VBA to pull data from multiple sources, process data, generate reports and graphs and so much more. Called as Macros they help automate repetitive task.
Here is what is included:
Table Of Content Chapter 1: Introduction to Macros in ExcelWhat is a macro?The importance of macros in ExcelWhat is VBA in a layman's language?Macro BasicsStep by step example of recording macros in ExcelEnable Developer Option Chapter 2: Your Fist VBA in ExcelWhat is VBA?Why VBA?Personal & business applications of VBA in excelVisual Basic for Applications VBA basicsEnable Developer OptionStep by step example of creating a simple EMI calculator in Excel Chapter 3: VBA Data Types, Variables & ConstantVBA VariablesExcel VBA Data-TypesConstant in VBA Chapter 4: VBA ArraysWhat is an Array?What are Advantages of arrays?Types of arraysVBA Array Demonstrated with ExampleTesting our application Chapter 5: VBA Excel Form Control & Activex ControlCreating VBA Form/GUI controls in ExcelHow to use ActiveX control in VBAPrerequisite Chapter 6: VBA Arithmetic Operators Chapter 7: VBA String Operators Chapter 8: VBA Comparison Operators Chapter 9: VBA Logical Operators Chapter 10: Excel VBA Call a SubroutineWhat is Subroutine?Why use subroutinesRules of naming subroutines and functionsSubroutine practical example Chapter 11: Excel VBA Function Tutorial: Return, Call, Examples Chapter 12: VBA Range ObjectsWhat is VBA Range?Introduction to Referencing Objects in VBAHow to refer to Excel VBA Range Object using Range propertyRefer to a Single cell using the Worksheet.Range PropertyCell PropertyRange Offset property