Contextures

Data Entry Popup List Kit

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.

Better Than Drop Down Lists

  • Use any font or font size, to make the list easier to read
  • Make the list longer (an in-cell drop down only shows 8 items at a time)
  • No typing necessary -- just click the item(s) that you want
  • In a long list, you can type one letter, to go to that section of the list
  • Make multiple selections, or limit to one selection -- set the rules for specific columns
  • Allow users to add new items (optional)

multi select listbox

How It Works

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.

Dependent Lists

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.

multi select listbox

Customize the Code in Easy Steps

To use the popup list, you will need the following Excel skills, to get your file ready:

  • create a named range (for the list of items) -- there are instructions and a video here: Create a Named Range
  • create drop down list(s) on the worksheet, based on the named range -- there are instructions and a video here: Create a Drop Down List

Then, it is easy to customize the Excel code:

  1. Open the Setup file that comes in the kit
  2. Select the options that you want
  3. Follow the simple steps to copy the forms and code to your file.

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.

customize the code

In the Kit

The DVMSP kit contains:

  • a 30 page user guide (PDF format), with written instructions and lots of screen shots
  • link to a step-by-step video that show how to copy the popup list and code into your file
  • instructions and screen shots, for copying the technique to your own workbooks
  • 3 Excel workbooks:
    • Setup File -- use this to customize the code, then copy it to your workbook
    • Practice File -- test the technique on this file
    • Demo File.-- see how the completed file works

NOTE: Windows only -- not guaranteed to work with Macintosh Excel

Add to Cart

View Cart

Customer Reviews

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

Excel Versions

The sample files were built in Excel 2010, and the screen shots show that version. You can follow the instructions in Excel 2007 or Excel 2013, with only minor differences in the worksheet appearance.

However, this technique is for Windows version only -- not guaranteed to work with Macintosh Excel.

Discounts for Multiple Items

Contextures Inc. is pleased to offer these discounts when you purchase more than one copy of the Data Validation Multi Select Premium Kit. The same discounts apply if you buy multiple Contextures products, such as 1 copy of PivotPower Premium, and 1 copy of Data Validation Multi Select Premium.

These percentage discounts are applied automatically to your order.

  • For 2 items -- 10% discount
  • For 3 items -- 15% discount
  • For 4 items -- 20% discount
  • For 5-19 items -- 25% discount
  • For 20 or more items -- 35% discount

Get the Data Entry Popup List Kit Now

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

Add to Cart

View Cart

How the Payment Process Works

  1. In the Add to Cart window, click the Checkout With PayPal button.
  2. You will be taken to a secure PayPal payment site, where you can
    • pay by credit card (click the "Don't Have a PayPal Account?" button.
         
    • OR pay through your own PayPal account (if you have one).
  3. After you make the payment, you will be redirected to a secure download page, on the e-junkie website.
  4. Within 30 minutes, you will also receive an email with a link to the download page. If you do not receive the link, please contact me at ddalgleish@contextures.com
  5. Your download will be available for 48 hours, or 5 downloads, whichever comes first.
  6. If you have any trouble with the download process, please contact me at ddalgleish@contextures.com

Licensing the Data Validation Multi Select Premium Kit

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.

Unconditional 30 Day Guarantee

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.

 Get Excel News

Last updated: May 25, 2016 4:25 PM