Excel with VBA-Excel
VBA stands for Visual Basic for Application. It is an event driven programming language used with MS-Excel, MS-Word. Accessing the VBA editor Go to File>> Option >> Customize Ribbon >> Tick Developer >> Press OK Click on Developer Ribbon and then click on Visual Basic. Shortcut: Press ALT+F11 This is the VBA interface. Writing the first Code ( Custom Formula) In VBA code is written in Modules. So, Modules can be inserted by navigating to Insert >> Module. Now in Module, Procedures are written. These are group of instructions (statements). There are two types of Procedure: a) Sub b) Function These both eliminates the need of writing the same from multiple times. This allows to make custom user defined functions. Here is the example of a user defined function in excel. So, the code snippet c...