How Macros Can Run Faster in Microsoft Excel

In this article, you will learn how macros can run faster.   Let us understand with an example: If you are working on long VBA codes for cal...

Create Drop Down Lists in Excel using Data Validation

In this article, you will learn how to make Excel drop down list from another workbook. While working on reports, you can make reports more secure so ...

Highlight Rows that Meet Criteria in Searchbox in Excel

In this article, we will learn how to highlight rows that meet criteria. This technique will be based on Conditional Formatting & regular formulas...

Evaluate Day Of The Week Using Format Cells In Microsoft Excel

Let's say you want to see the date to be displayed when you enter a date value in a cell as "Tuesday" instead of the actual date of January 27, 2014. ...

Custom Error Messages in Data Validation in Microsoft Excel 2010

Consider while creating a pre-set field for other users which will be helpful when entering the value that you have already set where you do not want ...

Cascading Drop Down List Using Conditional Formatting in Microsoft Excel

In this article, we will learn about how to create cascading drop down list using conditional formatting. To create the cascading drop down list we wi...

Automatic Spell Checker in Microsoft Excel 2010

If you are wondering how you can make Excel to spell check the data (typing error), in this article, you will learn how to automatic spell check in...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube