Contents
Excel’s capabilities are not limited to a set of built-in functions. By writing macros, you can create your own functions to perform non-standard tasks in Excel.
For example, a self-written macro can be attached to an icon and displayed on the Menu Ribbon. Or you can create a User Defined Function (UDF) and use it just like the rest of Excel’s built-in functions.
A macro is computer code written for Excel using the Visual Basic for Applications (VBA) programming language. The basic concepts of the VBA programming language are covered on our website in the VBA Tutorial. However, before you start writing VBA code, we recommend that you read the lessons that discuss the security of Excel macros and the Visual Basic editor.
Setting permission to use macros in Excel
Excel has built-in protection against viruses that can enter your computer through macros. If you want to run a macro in an Excel workbook, make sure the security settings are set correctly.
Click this link to learn more about macro security settings in Excel
Visual Basic editor
Excel has a built-in Visual Basic editor that stores macro code and interacts with the Excel workbook. The Visual Basic editor highlights errors in programming language syntax and provides debugging tools to track work and find errors in the code, thus helping the developer write code.
Click this link to learn more about Visual Basic Editor in Excel
Recording macros
The Excel macro recording tool is a great way to efficiently perform simple repetitive tasks. It can also be used as an aid in writing more complex macros.
Click this link to learn more about recording macros in Excel
Excel VBA Tutorial
For those who are just starting to learn the Excel VBA programming language, we offer a short introductory course on Visual Basic for Applications.
Click this link to go to the Excel VBA Tutorial