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.

Data Validation with Excel Formulas

Today’s post continues the discussion on data validation, introducing a new approach that utilized Excel formulas. This approach provides an additional level of flexibility without the need for complex macros or VBA.

Data Input for Datasets in Excel with VBA

While Excel provides the means of entering data directly into datasets, you can build important controls and features by processing data through a VBA script. This post will provide an overview of a user-friendly data input form to prepare data for processing and entry in VBA.