history of vba

What is Macros? A Macros is a piece of programming code that runs in excel environment, and it helps to automate routine…

VBA Date Format The Date Format function takes a date expression, and it returns a string containing an expression formatted according to…

VBA-M VBA-M is a fork of the inactive VisualBoy Advance project. It improves the capabilities and features of the emulator. VisualBoy Advance…

VBA Dim VBA Dim is a keyword that is used for the word dimension. It is also used to declare variable names…

VBA MID Function There arise many situations in day-to-day Excel life where we want to fetch the first substring, last substring, or…

VBA Do Until Loop The Do Until Loop is used when we want to repeat a block of code or a set…

VBA MsgBox The MsgBox is a dialog box in the excel VBA that can be used to inform the users of your…

VBA Do While Loop The Do While Loop is used when we want to repeat a set of statements as long as…

VBA Option Explicit “The VBA Option Explicit statement is used to declare the variables mandatory while writing codes. It is a secure…

VBA Editor The first step to working with VBA in excel is familiarized with the Visual Basic Editor also called the VBA…