Category Archives for "Excel VBA and Macros"

Macro Efficiency: Disabling Screen Updating

This is part 2 of the Macro Efficiency series where in we teach you how to code efficiently using Microsoft Excel VBA. This method which we are going to discuss today is recognized as one of the basic and the most important method for making the code efficient. The parameters which we are going to learn are regarding application.screenupdate. A small 2 line code will make your macro run faster. Sounds interesting ?

Get your Macros to work faster – Event Handling

In the series of Blog posts we are going to make you will find various tips and tricks regarding how to speed up calculation of macros in Excel VBA. This is the first among the other articles. 

Most of the time we make a great automation, great program and great software in Microsoft Excel. but we encounter a problem that all our automation is a bit slow. They take time to calculate and they are slow for each and every action. In a project of mine it once took around 3 minutes to run a simple sort macro. Lets learn the causes and the solution to this problem

Custom Lists in Excel Explained (Regular + VBA)

Introduction

You must be aware that when you write Monday in a cell and you click and drag it you could see that all the names of the days are populated in those cells which you have selected and even if you drag more than 7 it again starts the list from Monday. Do you know that you could also create these types of list at an ease. Such lists are known as custom list. Today i will be showing you 2 different ways by which you can create your own custom list. One method is the regular method and another one is a bit difficult method by using Excel VBA. Learning Excel VBA method is useful for 2 reasons:
1. Learn a bit of coding to implement in further projects
2. You want your clients to create their own list and hence give them ease of use by creating a list

Enable Developer Tab – Excel 2007 to Excel 2013

I have been asked by many of the Excel viewers regarding how to enable developer Tab.
There are different steps for different version. I have divided the Excel Versions into two groups one is Excel 2007 and another is Excel 2010 + (Including Excel 2013). The procedure for Excel 2010 and Excel 2013 is same. The main difference in Excel 2007 and Excel 2010 + is that in Excel 2010 + you can create your own custom tabs.  But before learning on how to enable developer tab we will first learn what is the use of developer tab. The reason is that many of our readers are not familiar with the use of developer tab.