Basic & Advanced VBA Macro in 30 Days in Hindi || Excel VBA Macro || Day -1

Basic & Advanced VBA Macro in 30 Days

VBA Programming: Introduction to VBA


What Is VBA? Need and Application of VBA
Working In the Visual Basic Editor: Project Explorer, Properties window, Object Browser, Standard Module and Sheet Module, Debugging mode, Breakpoints, Bookmarks, Watch window, immediate window and Locals window, Inbuilt VBE Help feature
Introducing the Excel Object Model: Application, Workbooks, Worksheet Objects.
Variable, Constant and Data types: Variable Naming rules, Declaring, Initializing Variables, Option Explicit, Object Variables.
Simple Dialog Boxes: Message boxes and Input boxes
Scope and lifetime of variables
VBA Sub and Function Procedures
Using VBA and Worksheet Functions
Working with Range Objects: Properties and Methods of Ranges – Range referencing, selection, Active cell, cells and offset properties, resize ranges, value, formula and text properties, clear, delete, copy, paste and format ranges, Filters, special cells method, union and intersect ranges, current region property, working with dynamic ranges, last cell, last row and last column
Workbooks and Worksheets: The Workbooks Collection, Getting a Filename from a Path, Files in the Same Directory, Overwriting an Existing Workbook, Saving Changes, The Sheets Collection, Worksheets, Copy and Move

@SharmajikaGyanTricks
#msexcel2016
#vbamacro
#exceltipshindi
#vbahindi