The InStr function locates a given substring inside the given string and returns the index of the first place of the substring.…
Insights
Excel VBA InStr Function
Practical notes on Excel, analytics, and building systems your team can run.
VBA InputBox
The VBA InputBox prompts the user for values. The dialogue box displays a message and anticipates a response from the user in…
VBA VLookup
One of Excel’s most powerful and flexible tools is the VLookup feature. It’s common to be compelled to code a VLookup macro…
VBA Option Explicit
Option Explicit helps to define variables when writing code. It’s possible that the developer misspelt a variable or forgot to define it…
VBA Workbooks Open
VBA Workbooks Open. A workbook is an object in Excel VBA. It can make chart sheets, cells and ranges, shapes, and chart…
Type Mismatch VBA
VBA Type Mismatch Error in Excel is a “Run Time Error,” and it is the number 13 error in this bracket. It…
VBA Date Format
VBA Date Format. The Date Format function accepts a date expression as input and returns a string comprising the expression in the…
Excel VBA Find
The Find function is often useful in VBA. You can use the Find tool to know a specific value or format in…
VBA Editor
The Visual Basic Editor, also known as VBA Editor, VB Editor, or VBE Editor, is a separate application that first needs to…
VBA Do While Loop
VBA Do while is a loop in which you have to specify a condition, and that condition must be true for the…