VBA

How To Add Scroll Bar To Excel Cell

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.

How To List All Excel Table Names

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.