Google-Like Search in Excel

Today’s post introduces a Google-like search, with search-as-you-type suggestions. While it’s possible to run basic searches with VLOOKUP and other techniques, this VBA approach can provide immediate search suggestions or recommendations for the user.

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 …

Add-in Tutorial: Name Manager Plus

Name Manager Plus has been developed by Excel Virtuoso as a new add-in to better manage named range references within an spreadsheet. The add-in permits uses to more easily adjust named range references, names, and permits the assignment of categories.

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. …