Contextures

Data Entry Search Popup 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 Entry Search Popup (DESP) kit -- it creates a popup list that makes it even easier to enter your data.

See how it works, in the video below, and download the demo file, to test it on your computer.

Latest version: 1.03, April 11, 2017 (added code to hide ALL button for single select columns)

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
  • To search a long list, type a few letters, to see only the items that contain that text
  • See the full text for long items, that are too wide to see in the list.
  • Make multiple selections, or limit to one selection -- set the rules for specific columns
  • Add items to cell in the order they were selected, or in A-Z order
  • Allow users to add new items (optional)

single or multi select

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.

To test the Data Entry Search Popup on your computer, download the demo file. The zipped file is in xlsm format, and contains macros. It is the same Excel workbook that was used in the demo video.

Search Long List

To find items in a long list, type a few letters in the Search box. The list is automatically filtered, to show only the items that contain the string of letter you typed.

search box in DESP

See Long Items Full Text

If there are long items in a list, click on an item to see its full text, in the box above the list. You'll be able to select the exact item that you need, even if many items are similar.

see full text of long items

Sort Selected Items

When you click on items to select them, they are added to the Selected list. Add items to the cell in the order in which they were selected, or click the Sort button, to change them to A-Z order.

see full text of long items

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 DESP kit contains:

  • a short Get Started guide (PDF format), with written instructions and screen shots
  • link to a step-by-step video that show how to copy the popup list and code into your file
  • Setup file with a macro that copies the popup list to your own workbooks
  • 3 Excel workbooks:
    • Setup File -- use this to customize the code, then copy it to your workbook
    • Test File -- test the technique on this file
    • Demo File -- see how the completed file works

NOTE: Excel 2007 and later, Windows only -- not guaranteed to work with Macintosh Excel

Add to Cart

View Cart

Excel Versions

The sample files were built in Excel 2016, and the screen shots show that version. You can follow the instructions in other versions of Excel, with only minor differences in the worksheet appearance

  • This kit is for Excel 2007 or later .
  • It is for Windows versions only -- not designed for Macintosh Excel

Discounts for Multiple Items

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.

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

Get the Data Entry Search Popup Kit Now

Click the Buy Now button, to get the Data Entry Search Popup (DESP) guide and Excel files. Step 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. Click the Buy Now button.
  2. You will be taken to a secure PayPal payment site, where you can
    • pay by credit card -- scroll down and click the "Pay with Debit or Credit Card" button.
    • OR click the "Log In" button, to 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.
  5. Your download will be available for 120 hours, or 5 downloads, whichever comes first.
  6. If you have any trouble with the download process, please contact me at ddalgleish@contextures.com
    NOTE: I'm in Canada, near Toronto, with business hours in the Eastern Time zone.

Licensing the Data Entry Search Popup Kit

The Data Entry Search Popup (DESP) 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 DESP code and userforms.

However, the setup, practice and demo workbooks in the DESP kit, and their contents, cannot be shared with others, except in your completed workbooks.

Unconditional 30 Day Guarantee

After you purchase the Data Entry Search Popup Kit, you may return it for any reason, within 30 days. Your purchase amount will be fully refunded.

Buy Now - $29 US

Pay with Credit Card or PayPal

Buy Now

 

Last updated: July 4, 2017 9:54 AM