Drop down lists make data entry easier, but they have limitations, such as small fonts, and no autocomplete. Overcome those limits with the Data Validation Multi Select Premium (DVMSP) kit -- it creates a popup list that makes it even easier to enter your data. See how it works, in the video below.
Latest version: 6.07, April 11, 2017 (added code to hide ALL button in single selection columns)
When you click on a cell that contains a drop down list, the popup list will appear. Quickly scroll through the list, then select a single item, or multiple items -- you'll make that rule when customizing the list.
To see how the popup lists works, watch this short video.
Most dependent lists work too -- Canada was selected in column E, and the City list for Canada is shown in the popup list. In the screen shot below, the multi-select list is showing. You can show a single select list, if you prefer, in any column.
To use the popup list, you will need the following Excel skills, to get your file ready:
Then, it is easy to customize the Excel code:
NOTE: The kit is designed for workbooks that do not have any
existing Selection event macros on the worksheet. If you plan to integrate
this code with existing code on the data entry sheet, you will need some
programming skills, or assistance from a programmer.
The DVMSP kit contains:
NOTE: Windows only -- not guaranteed to work with Macintosh Excel
Here is what our customers say about our Data Validation Multi-Select Premium product:
"This product is great, easy to use and customize to fit your needs. The autocomplete feature makes it easy for our employees to find what they are looking for in long lists.
This is a clean simple solution to a problem we were having. By adding a few macros we were able to make a form with drop downs reset after each use.
Have only had to reach out to get support once but heard back in under 10 minutes with the solution and had it fixed in another 5. What you get for the price is unbeatable. Highly recommended." -- Carl E., ulrich medical USA
The sample files were built in Excel 2010, and the screen shots show that version. You can follow the instructions in Excel 2007 or later versions of Excel, with only minor differences in the worksheet appearance.
However, this technique is for Windows version only -- not guaranteed to work with Macintosh Excel.
When you purchase more than one copy of a Contextures product, or purchase multiple products, in the same order, Contextures Inc. is pleased to offer the following discounts.
These percentage discounts are applied automatically to your order.
Click the Add to Cart button, to get the Data Entry Popup List (DVMSP) guide and Excel files. iStep by step purchase instructions are listed below.
NOTE: Windows only -- not guaranteed to work on Macintosh
The Data Validation Multi Select Premium (DVMSP) Kit licence is for a single (1) user. You may use the downloaded material for unlimited personal or business use, and you can share any workbooks that you create, in which you have inserted the DVMSP code and userforms.
However, the setup, practice and demo workbooks in the DVMSP kit, and their contents, cannot be shared with others, except in your completed workbooks.
After you purchase the Data Validation Multi Select Premium Kit, you may return it for any reason, within 30 days. Your purchase amount will be fully refunded.
Last updated: April 11, 2017 9:51 AM