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 For Loop A For loop is a repetition control structure allows a developer to be logical write a loop which needs…

VBA String Functions The string is the most common data type used to store data in Excel. Therefore String functions become so…

VBA Functions A function is a piece of code that performs a specific task and returns the result. Functions are mainly used…

VBA String Operator The string data is used to hold a sequence of characters that can consist of numbers, alphabets, special characters…

If Else If Statement If Then, If Then Else and If Else If statements allows the programmers to control the execution flow…

Switch Statement To execute a group of statements depending upon the value of an Expression, then we use the Switch Case. Here,…

VBA InputBox VBA InputBox is used to prompt the user to enter the values. This message box is used to displaying a…

VBA TRIM Function Excel is all about manipulating and working the data. These data are usually imported from other database channels or…