vba tips

Nested If Statement An If or ElseIf statement inside another If or ElseIf statement. The inner If statements execution is based on…

VBA Len Function What if you are given the sentence “Hello World, VBA is an Excellent Language!!” and you are asked to…

VBA Instr Function We often require finding the word from a sentence or entire Excel sheet to apply some formatting or to…

VBA Variables Variable is a specific memory used to hold values that are stored in a storage system and computer memory. You…

VBA LEFT Function Various functions are common in both Excel as well as VBA. Of all the many text functions, VBA LEFT…

VBA VLookup The VLookup is a worksheet function in excel, but we can also be used in the VBA. The functionality of…

VBA Workbooks Open In Excel VBA, Workbook is an object. It performs different types of purposes, such as chart sheets, cells and…

VBA Logical operator You can have more than one condition in the same line of your If and else If statements. To…

Excel VBA Tutorial VBA stands for Visual Basic for Applications, and event-driven programming language from Microsoft. It is now predominantly used with…

VBA Loops There is a situation when you need to execute a block of code several numbers of times. In general, statements…