Notes in Hindi

VBA programming notes in hindi

Using Properties and Methods 1
Understanding Parameters 2
The Object Browser 3
Understanding Object Hierarchy 4
Tools for Better Coding 5
Moving to Other Cells 6
Editing Specific Cells 7
Variables in Hindi 8
Arrays in Hindi 9
Constants in Hindi 10
Using Immediate Window in Hindi 11
Immediate Window in Hindi 12
Formatting Cells in Hindi 13
Object Variables in Hindi 14
IF Statement in Hindi 15
Select Case in Hindi 16
For Next Loop in Hindi 17
For Each Loop in Hindi 18
Do Loops in Hindi 19
With and End With in Hindi 20
Nesting Code in Hindi 21
Building Procedures in Hindi 22
Calling Procedures in Hindi 23
Passing Arguments to Procedures in Hindi 24
Building Intuitive User Interface in Hindi 25
Communicating with the User through the Message Box in Hindi 26
Gathering User Information with the Input Box in Hindi 27
Utilizing the File Dialog Object and Dialogs Collections in Hindi 28
Creating Customized Dialog Boxes with User Form Objects in Hindi 29
Creating Customized Dialog Boxes Advanced Controls in Hindi 30
Fonts & Backgrounds in Hindi 31
Creating a Counter in VBA in Hindi 32
String Handling Functions in VBA in Hindi 33
Range Selection and Manipulation in VBA in Hindi 34
Introduction to Workbook Object in Excel VBA in Hindi 35
Introduction to Range Object in Excel VBA in Hindi 36
Understanding Methods vs Properties in Excel VBA in Hindi 37
Using the .Value and .Text Properties in Excel VBA in Hindi 38
Introduction to Object Assignment in Excel VBA in Hindi 39
What are Named Arguments in Excel VBA in Hindi 40
What is Array and Why We Use Array in VBA in Hindi 41
Introduction to Sorting an Array in VBA in Hindi 42
What is 2-Dimensional Array in VBA in Hindi 43
Introduction to Dynamic Array in VBA in Hindi 44
What is UBound and LBound in Array in Hindi 45
How to Store Range Data into Array in VBA in Hindi 46
Most Used Array Functions in VBA Programming in Hindi 47
User Defined Functions in Hindi 48
Advanced User Defined Functions in Hindi 49
Creating an Ad in Hindi 50
Managing an Ad in Hindi 51
Internet & Excel in Hindi 52
Automating Internet with Excel VBA in Hindi 53
Communicating with Word using Excel VBA in Hindi 54
Communicating with PowerPoint using Excel VBA in Hindi 55
Modifying Menus & Toolbars in Hindi 56
Customizing Menus & Toolbars with VBA in Hindi 57
Command Bar Object in Hindi 58
Command Bar Control Objects in Hindi 59
Introduction to VBA 60
Introduction to Excel 61
Introduction to Programming 62
VBA overview and key benefits in Hindi 63
What are modules and procedures in VBA IDE in Hindi 64
Quick Review of Macros 65
Working with Macros 66
How to Use Visual Basic Editor (Programming Environment) 67
Advantages of VBA 68
Understanding the VBA Editor 69
Modules and Macros 70
About VBA Forms 71
Sub Procedures & Modules 72
Creating Forms 73
Using Controls and Their Properties 74
Running VBA Forms in Excel 75
VBA Syntax & Grammar 76
Objects – The Grammar 77