Send an Email Every Time When You Save Excel File

With Excel VBA, you can implementing features that are not even exist in Excel. In this tutorial we will be creating an auto emailing feature every time when you save your Excel file a macro will automatically fire and sending an email either to yourself or to whoever...

How to Align Any Excel Form Controls with Simple VBA

If you are someone who works with Excel Form Control a lot, then I think you will find the VBA script that I am going to share with you in this video to be very useful. Often times, one of the most painful steps when working with Form Controls is to align them; it is...

Create and Delete Multiple Worksheets with VBA

If one day your manager hand you an Excel file and ask you can you create worksheets for each of the company list in a column, and you see that there are approximately 100 items. And image if you have to create them one by one for a 100 times, that must be a super...

Files and Folders Management with FileSystemObject in VBA

In general when we write VBA scripts we either trying to automate an office application task like in Excel, Outlook, Word, or Access, or we are trying to implement a functionality to an existing program. One thing makes VBA versatile is its ability to work with...

A Better Way to Perform a Vlookup (or just any lookup) in VBA

Knowing how to perform a lookup task is important and critical in Excel. Majority of the spreadsheets out there probably have some sort of lookup formula embedded. Perform a Vlookup task is pretty easy on the Excel UI, you simply use the VLOOKUP (or INDEX/MATCH)...