VBA

Printing charts in Excel can be a very useful tool for presenting data analysis and visualizations to others. However, sometimes you may want to print only one chart on a whole page, instead of having multiple charts squeezed onto one page. This is where VBA comes in handy. In this article, we will explore the …

How To Print Only One Chart On A Whole Page In Excel VBA Read More »

In this article, I will tell you how to rename multiple sheets in excel with dates values.

In Excel, renaming multiple sheets can be a time-consuming task if done manually. Fortunately, there is a quick and easy way to rename multiple sheets based on the cell value using VBA code. This tutorial will guide you through the steps to create a VBA macro that renames each sheet in your workbook based on …

How To Rename Multiple Sheet In Excel Based On Cell Value Read More »

In this article, I will tell you how to insert a scrolling text box in excel worksheet. It will first insert a TextBox control and a ScrollBar control in the worksheet, and then add VBA macro code to process the scroll bar change event and display text in the TextBox control. It will also tell …

How To Insert Scrolling Text Box In Excel Read More »

This article will tell you how to use the VBA sub-procedure to catch the worksheet change event and then insert the current date time in the next adjacent cell. It will also tell you how to use VBA to create an excel function and call the function to insert the current date and time in …

How To Use VBA To Insert Current Date Time In Excel Read More »

This article will tell you how to get the excel active cell address and display the active cell address in a specified cell using a formula or VBA.

When there are huge data rows in your excel worksheet, you had better add a scroll bar to navigate the data rows. This article will tell you how to add a scroll bar to a cell range to scroll your data rows easily in the excel cell range.

In the previous article, I told you how to use the excel formula to count unique values and distinct values in excel. In this article, I will tell you how to define customized VBA functions to do the same thing using VBA.

Suppose there are multiple worksheets in your excel workbook, and you want to arrange the worksheets in alphabetical order by the worksheet tab name, how to do it? This article will tell you the methods of how to arrange excel worksheets in alphabetical order.

When I run the Microsoft Visual Basic for Application program from excel, the VBA window GUI shows Chinese language. But I want to show English language in the window GUI. This article will tell you how to do it.