Case Study: Custom VBA Tooltips

This post provides a case study of an advanced implementation of custom VBA tooltips. While Excel offers a built-in tooltips feature for data validation, its limited to displaying simple text messages. By implementing custom tooltips through VBA, you can provide users with dynamic validation hints and infographics.

Easy VBA Tooltips

One of the most difficult parts of spreadsheet design relates to making complex spreadsheets accessible to all users. In business settings, a select group may be trained on how to use a spreadsheet model, but staff turnover may result in training gaps. This is where instructions embedded within a spreadsheet—such …

The Boss Macro

We’ll make this an April Fools’ Day tradition. Last year, I created The Garbage Financial Statement — a prank financial statement that would flip data whenever entered into a cell, and subsequently move the data to an adjacent cell whenever the user attempted to delete it. I wouldn’t recommend sending …

Calling Subroutines with Worksheet and Workbook Events

Form and ActiveX Controls provide a user-friendly way to initiate Excel macros, but it may not always be clear to the user that a button needs to be clicked. If you find yourself including notes such as “please click button here”, you may want to consider Worksheet and Workbook events …

Free Excel Template: Employee Timesheet

We’re releasing another free item in the Excel Virtuoso Portfolio. This item is a basic excel based employee timesheet template, useful for small businesses or volunteer organizations. With a user friendly interface and simple navigation, employees can keep an accurate count of hours worked each day.

Speed Test: VBA Range Object

It’s worth taking a deeper look at the Range object, as it is a central element to reading, writing, and modifying data on a worksheet. This post uses a classic speed test to time the most efficient method of interacting with a spreadsheet.

Official Launch of Excel Virtuoso

Dear Readers- I’m very excited to announce the official launch of Excel Virtuoso. This blog is dedicated to providing comprehensive guides, tips, and tricks to help professionals harness the full power of Microsoft Excel. As a business tool, nothing comes close to Excel in terms of pure flexibility and potential. …

Protecting Layout and Formulas

While one of Excel offers users the ability to interact with and modify any area of a spreadsheet, there are times where you may not want users of your spreadsheet application to inadvertently change contents. The ability to protect certain parts of a spreadsheet allows for full control, while providing …