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)
-----------------------------------------------------------------------------------------------------------------------------
ALL COMPUTER PDF NOTES AVAILABLE IN HINDI & ENGLISH MEDIUM
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
COMPUTER NOTES FOR TEACHERS AVAILABLE IN HINDI & ENGLISH MEDIUM
Dear Teachers
ऐसा कंप्यूटर नोट्स जिसे आप पढ़कर बच्चों को आसानी से पढ़ा सकते हैं।
यह नोट्स केवल कंप्यूटर इंस्टिट्यूट एवं टीचर्स के लिए हैं।
इस नोट्स में आप अपना Watermark, Header / Footer और या Logo भी लगा सकते हैं।
यदि आपको नोट्स खरीदने से रिलेटेड कोई भी problem आती है तो आप हमें Call या WhatsApp कर सकते हैं। Call / WhatsApp: +91 9650597419
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
COMPUTER PDF NOTES IN ENGLISH
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
COMPUTER PDF NOTES IN HINDI
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
BASIC COMPUTER PDF NOTES IN ENGLISH
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
BASIC COMPUTER PDF NOTES IN HINDI
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
MS WORD PDF NOTES IN ENGLISH
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
MS WORD PRACTICE ASSIGNMENT FILE
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
MS WORD PDF NOTES IN HINDI
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
MS EXCEL PDF NOTES IN ENGLISH
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
MS EXCEL PDF NOTES IN HINDI
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
MS EXCEL PRACTICE ASSIGNMENT FILE
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
INTERNET PDF NOTES IN HINDI
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
COMPUTER / LAPTOP REPAIRING NOTES IN HINDI
BUY NOW DOWNLOAD NOW
-----------------------------------------------------------------------------------------------------------------------------
0 Comments