Online Computer Course Join Now
Software Engineering Course | Duration: 1 Year | Fees: 1500/- Monthly | Learn 25+ Language | Call / WhatsApp: +91 9650597419 (Vinay Sir) | Address: Sec - 36, Narsinghpur, Gurugram, Haryana
All Computer Notes | Practice Assignment | Hindi & English Medium Computer PDF Notes | Computer eBooks | Call / WhatsApp: +91 9650597419 (Vinay Sir) Grow Your Coaching Business 10x with your own coaching app | अपने नाम से Teaching App बनवायें | Call / WhatsApp: +91 9650597419 (Vinay Sir)
1. CCC PDF Notes Buy Now
2. Basic Computer PDF Notes Buy Now
3. DCA PDF Notes Buy Now
4. ADCA PDF Notes Buy Now
5. PGDCA PDF Notes Buy Now
6. MS Office PDF Notes Buy Now
7. MS Word PDF Notes Buy Now
8. MS Excel PDF Notes Buy Now
9. Adv. Excel PDF Notes Buy Now
10. MS PowerPoint PDF Notes Buy Now
11. Internet PDF Notes Buy Now
12. Tally Prime PDF Notes Buy Now
13. HTML PDF Notes Buy Now
14. CSS PDF Notes Buy Now
15. Java Script PDF Notes Buy Now
16. C language PDF Notes Buy Now
17. C++ PDF Notes Buy Now
18. J Query PDF Notes Buy Now
19. WordPress PDF Notes Buy Now
20. PHP PDF Notes Buy Now
21. VBA Macro PDF Notes Buy Now
22. Python PDF Notes Buy Now
23. Android PDF Notes Buy Now
24. Digital Marketing PDF Notes Buy Now
25. Computer Repair PDF Notes Buy Now

Lesson 1. About Excel VBA


About Excel VBA 
VBA stands for Visual Basic for Applications, and event driven programming language from Microsoft. It is now predominantly used with Microsoft Office Applications, Such as MS Excel, MS Word & MS Access.

What is VBA
VBA stands for Visual Basic for Applications. And event driven Programming Language from Microsoft with Microsoft Office Applications. Such as MS Word, MS Excel, MS Access.

VBA allows you to automate various activities in excel, Such as generating reports, preparing charts & graphs doing calculations etc. This automation activity is also known as Macro.

VBA helps to build customized applications and solutions to enhance the capabilities of these applications.

The advantage of this facility is that you don't have any need to install visual basics on your desktop, and installing office will ultimately help you to achieve the purpose. Also you can build very powerful tools in MS Excel using linear programming.

VBA can use in all office versions. VBA is a high level language. VBA is a Subset of Visual Basic 6.0.

BASIC stands for Beginners All Purpose Symbolic Instruction Code.


Why VBA?

Some points clear to you why use VBA such as:

1. VBA uses simple English statements to write the instructions.

2. Creating the user interface is a drag, drop and align the graphical user interface controls in VBA.

3. VBA is a very simple to learn and required basics programming skills.

4. VBA enhance the functionality of excel by allowing you to make excel behave according to your need.

Application in VBA

You think why to use VBA in Excel as MS Excel itself provides loads of inbuilt functions.

MS Excel provides only essential inbuilt functions that may not be sufficient to perform complex calculations. Under such circumstances, VBA becomes the most transparent solution.

For Example: Using Excel's built in formulas is tough to calculate the monthly repayment of the loan. But it is easy to program a VBA for this kind of calculations.

VBA Basics

First, You need to know about the basics before starting or write any code. There are some basics given below.

Variable: Variables are the memory locations. and to work with VBA, You will be required to declare variables.

For Example: Suppose (2x+5y) Where x=1, y=2, in this given expression, x and y are the variables or can be assigned any numbers. i.e., 3 and 4 respectively.

Rules for Creating Variables

1. Don't use reserved word: Reserved words are those words which have special meaning in VBA, so you can't use them as variable names.

2. The variable name cannot contain space: You cannot define a variable name with space such as the Last Number. You can use LastNumber or Last_Number.

3. Use Descriptive names: Use descriptive names such as price, quantity, subtotal etc. This will make your VBA Code easy to understand.

Arithmetic Operator    

We use the BODMAS Rule during brackets of division, multiplication, addition and subtraction when working with an expression which uses multiple different arithmetic operators.

1. + for addition
2. - for subtraction
3. * for multiplication 
4. / for division

Logical Operator

The concept of the logical operator is also applied when working with VBA such as.
1. If statements
2. AND
3. OR
3. NOT
4. TRUE
5. FALSE

Happy Learning
Thanks for Visit This Post. Computer Related Any Query Please Contact Us.
Call / WhatsApp: +91 9650597419 (Vinay Sir)

Post a Comment

0 Comments

All Computer Notes

Basic Computer Notes
1.Basic Computer Notes in English
2.Basic Computer Notes in Hindi
3.Computer Related Full Form
4.Computer Shortcut Keys
5.Keyboard Symbols Name
MS Word Notes in Hindi
1.MS Word Practical Notes
2.Chapter1: Introduction to MS Word
3.Chapter 2: Some Basic Point of MS Word
4.Chapter3 : MS Word - File Menu
5.Chapter 4: MS Word - Home Menu
6.Chapter 5: MS Word - Insert Menu
6.Chapter 5: MS Word - Insert Menu
7.Chapter 6: MS Word - Page Layout Menu
8.Chapter 7: MS Word - References Menu
9.Chapter 8: MS Word - Mailing Menu
10.Chapter 9: MS Word - Review Menu
11.Chapter 10: MS Word - View Menu
MS Word Notes in English
1.Chapter1: MS Word Home Menu
2.Chapter2: MS Word Insert Menu
3.Chapter3: MS Word Page Layout Menu
4.Chapter4: MS Word References Menu
5.Chapter5: MS Word Mailings Menu
6.Chapter6: MS Word Review Menu
7.Chapter7: MS Word View Menu
MS Excel Notes in Hindi
1.Chapter1: Introduction to MS Excel
2.Chapter2: MS Excel Home Menu
3.Chapter3: MS Excel Insert Menu
4.Chapter4: MS Excel Page Layout Menu
5.Chapter5: MS Excel Data Menu
6.Chapter6: MS Excel Review Menu
7.Chapter7: MS Excel View Menu
MS Excel Notes in English
1.Chapter1: Introduction to MS Excel
2.Chapter2: MS Excel Home Menu
3.Chapter3: MS Excel Insert Menu
4.Chapter4: MS Excel Page Layout Menu
5.Chapter5: MS Excel Data Menu
6.Chapter6: MS Excel Review Menu
7.Chapter7: MS Excel View Menu
MS PowerPoint Notes in English
1.Chapter1: Introduction to MS MS PowerPoint
2.Chapter2: MS PowerPoint Home Menu
3.Chapter3: MS PowerPoint Insert Menu
4.Chapter4: MS PowerPoint Design Menu
5.Chapter5: MS PowerPoint Transitions Menu
6.Chapter6: MS PowerPoint Animations Menu
7.Chapter7: MS PowerPoint Slide Show Menu
8.Chapter8: MS PowerPoint Review Menu
9.Chapter9: MS PowerPoint View Menu
MS PowerPoint Notes in Hindi
1.Chapter1: Introduction to MS PowerPoint
2.Chapter2: MS PowerPoint Home Menu
3.Chapter3: MS PowerPoint Insert Menu
4.Chapter4: MS PowerPoint Design Menu
5.Chapter5: MS PowerPoint Transitions Menu
6.Chapter6: MS PowerPoint Animations Menu
7.Chapter7: MS PowerPoint Slide Show Menu
8.Chapter8: MS PowerPoint Review Menu
9.Chapter9: MS PowerPoint View Menu
MS Excel Formula Notes
1.How to Add in Excel
2.How to Subtract in Excel
3.How to Multiply in Excel
4.How to Divide in Excel
5.MAX Formula in Excel
6.MIN Formula in Excel
7.ROMAN Formula in Excel
8.SQRT Formula in Excel
9.POWER Formula in Excel
10.LCM Formula in Excel
11.GCD Formula in Excel
12.FACT Formula in Excel
13.LOWER Formula in Excel
14.UPPER Formula in Excel
15.PROPER Formula in Excel
16.LEFT Formula in Excel
17.RIGHT Formula in Excel
HTML Notes
Chapter 1 : Introduction to HTML
Chapter 2 : HTML Versions
Chapter 3 : HTML DOCTYPE Declaration
Chapter 4 : HTML Attributes
Chapter 5 : HTML Heading Tag
Chapter 6 : HTML Text Formatting Tag
Chapter 7 : HTML Anchor Tag
Chapter 8 : HTML Image Tag
Chapter 9 : HTML List Tag
Chapter 10 : HTML Table Tag
Chapter 11 : HTML Marquee Tag
Chapter 12 : HTML Preformatted & Horizontal Tag
Chapter 13 : HTML Image Tag
Chapter 14 : HTML Anchor Tag
Chapter 15 : HTML Audio Tag
Chapter 16 : HTML Video Tag
Chapter 17 : HTML Iframe Tag
Chapter 18 : HTML Form Tag
Chapter 19 : HTML Website Layout
Online Computer Course Join Now
Computer PDF Notes | E-books | Practice Assignments | Project File | Call / WhatsApp: +91 9650597419 (Vinay Sir)
1. CCC PDF Notes Buy Now
2. Basic Computer PDF Notes Buy Now
3. DCA PDF Notes Buy Now
4. ADCA PDF Notes Buy Now
5. PGDCA PDF Notes Buy Now
6. MS Office PDF Notes Buy Now
7. MS Word PDF Notes Buy Now
8. MS Excel PDF Notes Buy Now
9. Adv. Excel PDF Notes Buy Now
10. MS PowerPoint PDF Notes Buy Now
11. Internet PDF Notes Buy Now
12. Tally Prime PDF Notes Buy Now
13. HTML PDF Notes Buy Now
14. CSS PDF Notes Buy Now
15. Java Script PDF Notes Buy Now
16. C language PDF Notes Buy Now
17. C++ PDF Notes Buy Now
18. J Query PDF Notes Buy Now
19. WordPress PDF Notes Buy Now
20. PHP PDF Notes Buy Now
21. VBA Macro PDF Notes Buy Now
22. Python PDF Notes Buy Now
23. Android PDF Notes Buy Now
24. Digital Marketing PDF Notes Buy Now
25. Computer Repair PDF Notes Buy Now