What is a layman’s language in a computer?<\/h3>\n
To perform an activity on the computer, you have to tell the commands to the computer and these commands are said in layman\u2019s language. Layman\u2019s language is very simple and easy to understand.<\/span><\/p>\n Computer programming is a set of actions we tell the computer to do. You can also use english statements to tell the computer what to do and these statements fall in the category of high level languages. VBA is a high-level language that is used to develop powerful excel programming.<\/span><\/p>\n In VBA, we can write the instructions in English for creating the applications. VBA is one of the programming languages which is easy to learn and it also has an user interface which is user friendly in such a way that the user can drag and drop the interface controls.\u00a0<\/span><\/p>\n MS-Excel itself provides a lot of inbuilt functions but they provide only the essential and common functions. Those functions would not be the solution to our complex calculations. To overcome this, we use VBA as it is one of the most transparent solutions.<\/span><\/p>\n For example, saving each worksheet as a pdf seems to be a tiresome task. But, it\u2019s easy to do if we use VBA.<\/span><\/p>\n The place where the user writes the code is called modules.<\/span><\/p>\n To insert a module, follow the step:<\/b><\/p>\n Go to insert and click on the module. Once this is done, the window creates\u00a0 \u2018module1\u2019. Inside a module, a user can write the VBA code with procedures followed. The procedure is the series of VBA statements instructing what to do.<\/span><\/p>\n Group of statements which instructs Excel, what and how to perform are procedures.\u00a0 The task can either be simple or complex and it all depends on the procedure. The good practise is to keep the code simple and small. Sub and Function are two main types of procedures.<\/span><\/p>\n A group of statements which is reusable and can be called anywhere in the program is known as function. This completely saves the time by eliminating the need of writing the same logic as code again and again. This widely helps the programmers to split the big programs into small and simpler functions. The user can write user-defined functions and those statements are segmented between Function and End Function.<\/span><\/p>\n Sub-procedures perform the work more like functions. The function can or cannot return a value and the sub-procedures do not return a value. They are also called even without a call keyword and they are written between the sub and end substatements in the code editor.\u00a0<\/span><\/p>\n The user comments in the program for user information and better understanding. It includes information about the programming and the author of the program. Comments are ignored while executing the program.<\/span><\/p>\n There are two ways to insert comments in the code:<\/span><\/p>\n Let’s get into the basics of VBA:<\/span><\/p>\n Declaration of variables are required for memory locations.\u00a0<\/span><\/p>\n Rules for creating variables:<\/b><\/p>\n a. No spaces between the variable name:\u00a0<\/span><\/p>\n A variable name could not contain space in between the words. So, if you want to create a variable such as cost price, then you have to type the variable name as cost_price.<\/span><\/p>\n b. Use a meaningful name:<\/span><\/p>\n Meaningful names makes your code easy to read and it looks more professional.<\/span><\/p>\n c. Avoid using reserved words:\u00a0<\/span><\/p>\n Reserved words have special meaning in excel and hence it is not accessible as variable names. Example: lecturer<\/span><\/p>\n The BODMAS rule applies here also, so consider it while working with the expressions using multiple different arithmetic operators. The types of operators are:<\/span><\/p>\nWhy VBA?<\/h3>\n
Applications of VBA<\/h3>\n
VBA Terminologies<\/h3>\n
1. Modules<\/h4>\n
![\"Insert](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/06\/modules.png\")
<\/a><\/p>\n2. Procedure<\/h4>\n
<\/a><\/p>\na. Function<\/h5>\n
b. Sub-Procedures<\/h5>\n
3. Comments<\/h4>\n
\n
<\/a><\/p>\nIntroduction to Visual Basic for Applications<\/h3>\n
1. Variable<\/span><\/h4>\n
2. Arithmetic operators in VBA<\/h4>\n