In this article we will show you how to add a sheet to an Excel workbook using VBA. There are 2 different methods detailed below in order to do this.

How to Link Sheets Using Visual Basic in Excel. Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use ...

How to Read the Data From an Excel Sheet Using VB Macros Coding. Excel sheets read data in cells using cell references, which are the addresses that identify each cell. Visual Basic macros also ...

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

In this article you will learn how to create checkboxes which are automatically linked to particular cells. VBA doesn't allow the creation of multiple checkboxes at once. You can manually link ...

How to open multiple links from Excel at once To open multiple links from Excel at once, you have to insert a custom VBA script in your Excel sheet. Follow the instructions listed below: ...

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.