Microsoft Excel offers Visual Basic for Application (VBA) as a scripting tool to let you add additional functionality to your Excel spreadsheets. You can use VBA to ...

Microsoft Excel lets you add two types of buttons to a worksheet: option buttons and toggle buttons. Option buttons, also referred to as radio buttons, let you choose one item from a list. Toggle ...

A Microsoft Excel Workbook consisting of several worksheets can be split into individual files with minimal manual intervention. This can be done with the help of Excel Worksheet Separator: a powerful ...

How to add a UserForm to aid data entry in Excel Your email has been sent When you need a user-friendly data input process, create an Excel UserForm. Users who are unfamiliar with Excel will find ...

In this month’s installment of my Excel dashboard series, I’m going to show you a trick that will give you the ability to control an entire dashboard with one menu — in this example, a radio button ...