Author: Pushpendu Roy Karmakar

Here is an example of a VBA program that you can use to shut down a Windows PC when a button is clicked: This program uses the Shell function to execute the shutdown command with the -s and -t 0 …

Lesson#187: VBA program to shutdown PC Read more →

In this post, we shall learn a simple to make a digital clock with VBA on your excel sheet. Now paste this VBA macro that you can use to create a digital clock on your worksheet, To use this macro, …

Lesson#185: How to make a digital clock with VBA Read more →

Here I shall show how entered value can be divided by 100 with a button in VBA. Here is the VBA macro that will automatically divide the value of the active cell by 100 when a command button is clicked: …

Lesson#184: Entered value divided by 100 with a button in VBA Read more →

Here we are going to learn a VBA code to insert zeroes in all empty cells in a selected range. Here is your VBA macro code: To use this macro, select the range that you want to check for empty …

Lesson#183: Insert zeroes in all empty cells in a selected range with VBA Read more →

Here I shall show you a VBA code that colors all empty cells in red in a selected range. Here is a VBA macro that you can use to insert zeroes in all empty cells in a selected range: To …

Lesson#182: Color all empty cells in red in a selected range with VBA Read more →

Here is a VBA macro that you can use to add a prefix to the selected cells: To use this macro, select the cells to that you want to add the prefix and run the macro. It will prompt you …

Lesson#181: VBA To Add A Prefix to Selected Cells Read more →

Here we shall learn a code that will copy a color from one cell to another using VBA. Here is a function in VBA that you can use to copy the interior color of a target cell to the active …

Lesson#180: How do you copy a color from one cell to another? Read more →

Here I shall make a VBA code to Count cells by color in Excel from a reference cell color. Here is a function in VBA that you can use to count the number of cells in a specified range that …

Lesson#179: Count cells by color in Excel from a reference cell color with VBA Read more →

In this article, I shall give you a VBA code that will delete all blank sheets at once. Here is a VBA program that will delete all blank worksheets in the active workbook: To use this code, open the Visual …

Lesson#178: Delete all blank sheets with VBA Read more →