Activate full-screen feature and disable window resize button of an Excel workbook using VBA in Microsoft Excel.

In this article we will learn how to activate full-screen feature and disable window resize button using VBA. Logic explanation We have created â€...

Countdown in status bar using VBA in Microsoft Excel

If you are wondering how can I create timer in excel Question: A count down from 30 to 0 seconds is to be displayed in the status bar. Answe...

Double Click to add/remove Tick

In this article, we will use before double click event of the worksheet to check and uncheck the cell. Raw data consists of some food items. We want ...

Some handy Personal Macros: Return Column Letter for column number.

This is good if you like to use statements like Range("A1") instead of cells(1,1). So, for example ColLetter(1) = A, ColLetter(2) = b, ... , ColLet...

Getting last blank cell

If you want to know the last blank cell of your column, ignoring the blank cells within that column, you can use below code.  This code will store th...

Change the selection with one or more areas to Values using VBA in Microsoft Excel

In this chapter, we are going to learn how to change the selection with one or more areas to values using VBA in Microsoft Excel.   Let’s t...

Change a Column or Columns to values using VBA in Microsoft Excel

In this chapter you will learn, how to change all the cells in the active sheet to values, using VBA in Microsoft Excel. Let’s take an example and ...

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 Google PlusVisit Us On Youtube