» Conditional Statements:Ĭonditional statements are very useful in any programming, this will give you to perform comparisons to decide or loop through certain number of iterations based on a criteria. The symbol is called an Operator and the Variable or Value is called an Operand. To perform any operation we required minimum one symbol and one Variable or Value. We we are doing anything with one are more values is called an operation or task.
You can automate such king of tasks using VBA. Most of the times, we do the same kind of tasks daily in our day to day work. It allows you to automate the task which you are doing manually and repeatedly. VBA is a programming language for MS Office Application, which stands for Visual Basic for Applications. And can write and edit basic macros to accept the inputs from the user and show the popup messages. By end of this session you will understand the Excel VBA environment and you will be able to Record and Run a Macros. This section is for beginners with no knowledge of Excel Macros or VBA.