Contextures

Data Entry Popup List Kit

Use this Data Entry Popup List kit to quickly add popup lists to your workbook. Then, click any cell that has a drop down list, and click the popup to choose items.

This short demo shows how the popups work - it's quick and easy to enter data this way!

Better Than Drop Down Lists

Drop down lists make data entry easier, but these popup lists are even better!

  • Use any font or font size, to make the list easier to read
  • Make the list longer to see more of the items at once
  • No typing necessary -- just scroll, and click the item(s) that you want
  • In a long list, type one letter, to go to that section of the list
  • Set rules per column - multiple selections, or limit to one selection
  • Let users add new items in some columns (or not!)

single or multi select

Basic Excel Skills

To set up the popup lists, you don't need any programming skills. You just need a couple of basic Excel skills, to get your Excel file ready:

  • create named ranges for the list of items that appear in the popup list
  • create drop down lists on the worksheet, where you want to popups to appear

NOTE: The popup lists will work with most dependent drop downs too, if your workbook has those

Easy to Customize

Once your workbook is ready, open the popup kit's Setup file, to quickly customize the popups. When the Setup file opens, you'll see a DVMSP tab at the top of Excel, to guide you through the Setup steps

In the Setup file, it's easy to customize your popups -- just select the options that you want, from drop down lists

customize the code

Then, simply select the workbook and worksheet where you want the popups to appear, and click OK.

The Setup file puts all the pieces into your workbook automatically, and you're ready to go!

In the Popups Kit

The kit contains the following files:

  • 3 Excel workbooks:
    • Demo File -- see how the completed file works
    • Setup File -- use this to customize the popups, and add them to your file
    • Practice File -- (optional) practise with this file, before adding popups in your file
  • Get Started Guide - quick intro on how to use the kit
  • User guide (PDF format), with written steps and screen shots
  • Video links - see how to customize the popup lists

Customer Reviews

Here is what our customers say about our Data Entry Popup List kit:

  • "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 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 versions.
  • 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 Popup List Kit Now

Click the Add to Cart button, to get the Data Entry Popup List guide and Excel files. Step by step purchase instructions are listed below.

NOTE: Popup Kit product name in cart is DataVal_MultiSelect_Prem (DVMSP)

Add to Cart

View Cart

How the Payment Process Works

  1. To start your purchase, click the Add to Cart button.
  2. In the shopping cart, click the orange button – Check out with PayPal
  3. On the PayPal page, scroll down a bit, and click the grey button – Pay with Debit or Credit Card
  4. That takes you to the secure PayPal Guest Checkout, where you can fill in your information
  5. Then, click the Pay Now button, to complete the purchase.
  6. After you make the payment, you will be redirected to a secure download page, on the e-junkie website.
    NOTE: You will also be invited to join the Contextures mailing list, for weekly Excel news. If you check the box, you will be added to the list right away, and you can unsubscribe at any time.
  7. 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
  8. Your download will be available for 48 hours, or 5 downloads, whichever comes first.
  9. If you have any trouble with the download process, please contact me at ddalgleish@contextures.com

Licensing the Data Entry Popup Kit

The Data Entry Popup (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 Entry Popup Kit, you may return it for any reason, within 30 days. Your purchase amount will be fully refunded.

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.

Product Updates

If this product is updated in the future, you will be able to download the latest version, at no additional cost. Product updates are announced in the Contextures Weekly Excel News, and the latest version numbers are shown at the bottom of the Contextures Excel Products page.

______________________________

Product Info: Data Entry Popup Kit, Ver 6.13, 23-Jan-19

Product Code: DataVal_MultiSelect_Prem (DVMSP)

______________________________

 

 

"clean simple solution...
Highly recommended"
-- Carl E

 

 

Add to Cart

View Cart

 

 

Questions - ask Debra

 

 

Last updated: January 16, 2020 4:33 PM