VBA

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.

When you want to input data into excel cells, you can input it directly. But when there are so many rows in your worksheet, you may need to scroll a lot of rows to input the new row data. With the excel user forms, you can input data with forms which likes the usually used …

How To Create UserForm In Excel VBA Read More »

Recently when I run an excel VBA command in excel immediate window, it prompts the error message compile error expected expression. This article will tell you how to fix this error easily.

The Excel Range object provides several properties. This article will tell you how to use the Range.End property to move the active cell in the specified direction to the first empty or non-empty cell.

When you use tables in excel worksheets, you always need to know the table names in those worksheets. This article will tell you how to list all excel table names in your excel workbook both manually and using VBA.