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!
Drop down lists make data entry easier, but these popup lists are even better!
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:
NOTE: The popup lists will work with most dependent drop downs too, if your workbook has those
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
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!
The kit contains the following files:
Here is what our customers say about our Data Entry Popup List kit:
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
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 guide and Excel files. Step by step purchase instructions are listed below.
NOTE: Popup Kit product name in cart is DataVal_MultiSelect_Prem (DVMSP)
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.
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.
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)
Last updated: January 16, 2020 4:33 PM