VBA Function To Check If A File Is Open

Jun 19, 2019 | Excel, VBA

In this tutorial I will share a VBA Function (User-Defined Function) that can detect whether if a file is currently opened. data-ad-client="ca-pub-3255865697013143" data-ad-slot="2278613244" data-ad-format="auto" data-full-width-responsive="true"> VBA...

Save a Backup Every Time When You Save Excel File

Jun 11, 2019 | Excel, VBA

If you are working on a very critical project (like an audit), and you would like to keep a record of things every time when you save your Excel file. Despite Excel doesn’t provide the feature – save a backup when saving -, we however, can create the...

Send an Email Every Time When You Save Excel File

Jun 11, 2019 | Excel, VBA

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...

Create an Excel Investment Portfolio Tracker Template

Jun 10, 2019 | Excel, Excel General

Excel has has improved much since the early day when I started using Excel 2003. With the latest Office 365 update, you can now use the stocks feature to import live stock information. In this tutorial, we will be learning how to build the a Investment Portfolio...

How to Align Any Excel Form Controls with Simple VBA

Jun 4, 2019 | Excel, 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...