Excel VBA Macro

Getting the Next Sheet Name

This post will guide you how to get the next sheet name in your current worksheet in excel. How do I get the next sheet name with VBA code in excel. Getting the Next Sheet Name If you want to quickly get the next sheet name in your active worksheet, you can define a user… read more »

Print All Options in drop-down List

This post will guide you how to print all options in a drop down menu list in a worksheet. How do I print all options in a drop down menu into separate printout in excel. How to print all options in a drop down menu with VBA code in excel.   For example, there is… read more »

Dynamic Command Button Name

This post will guide you how to make a dynamic command button so that its name is labeled as the results of a specific cell in excel. For example, if you create a command button and want its name be read from cell B1. So if the value of Cell b1 changed, and the command… read more »

Check If a Cell contain Image/Picture

This post will guide you how to check if a specific cell contains an image or picture in excel. Is it possible to check if a cell contains an image. This post will guide you how to define a User Defined Function to determine if an image exists in a specified cell. Or how to… read more »

Click or Double Click Cell to Show userform

This post will guide you how to use an Excel Macro VBA code to show a specified user form while clicking a cell or double clicking a cell in one cell in excel. How to open a user form just by clicking or double click on a cell. How to raise a User Form by… read more »

Find and Replace Alt Enter (Line Breaks) with Space

This post will explain that how to find Alt + Enter characters or line breaks in the range of cells and then replace it with space character or other specific characters in excel. When you want to create a line break in a cell in excel, you just need to press Alt + Enter keys…. read more »

Quickly Get Sheet Name

This post explains that how to get the sheet name only in your current worksheet in excel. How do I insert the current worksheet’s name into one cell quickly. Get Sheet Name with Formula If you want to quickly get current worksheet name only, then inert it into one cell. You can use a formula… read more »

Adding a horizontal Average Line to a Chart or Graph

This post explains how to add a horizontal average line to an existing Excel chart or graph in excel. How do I add a horizontal average line to a chart or graph gives loads of context for the viewer. How to use Excel VBA Macro to add a horizontal average line to the existing chart… read more »

Delete Every Other Row

This post will guide you how to delete every other row by filter command in Excel. How do I delete every other row in a selected range on a worksheet by Excel VBA Macro. Delete Every Other Row with Filter command To delete every other row in Excel, you need to filter alternate rows, and… read more »

Save Selection or Entire Workbook as PDF

This post will explain that how to export or save your current selection range in your worksheet or the entire workbook as a PDF file in Excel. It is a great way of sharing excel worksheet or the entire workbook as PDF document. How do I create an excel VBA Macro to save or convert… read more »

Sidebar