|
Home > Validation > Drop Downs > Popup Data Validation Select Popup ToolWith the Data Validation Select Popup (DVSP) tool, you can add popup lists to Excel workbooks. Set the rules for the pop-up lists -- allow single item selection in some columns, allow multi-selection in other columns. You can even let people add new items to some lists.
Author: Debra Dalgleish |
The Data Validation Select Popup tool lets you show a popup list when you click on a cell that contains a drop down list. Quickly see all the items in the list, instead of slowly scrolling through a long list.
Then, select a single item from the list, or multiple items -- all your selections are added to the active cell. For example, this screen shot shows a popup in the Region column, where only one item can be selected.

Or, you can allow multiple selections, like the list of Cities shown In the screen shot below. Most dependent lists will also work in the DVSP tool, as you can see in this example:

To see how the multiple selection popup lists works, you can watch this short video.
To follow along with the DVSP demo, go to the Download section at the bottom of this page, and download the DVSP Demo workbook.
Next, watch this video to see the DVSP setup file steps, and there are written instructions in the Setup file.

To use the DVSP tool, you will need the following Excel skills, to get your file ready:
Here are important notes about using the DVSP tool:
There is no technical support provided for the DVSP tool. Use the tool as is, and at your own risk.
For more tips and instructions, visit the following pages:
-- DVSP Frequently Ask Questions (FAQ) page
Note: The DVSP tool is a free version of the popular DVMSP tool that I sold for several years. In the videos, screen shots and written steps, you might see "DVMSP", instead of "DVSP".
Download DVSP FilesDVSP Demo: To see how the DVSP tool works, you can download the Excel Data Validation Selection Popup (DVSP) Demo workbook. The file is in xlsm format, and is zipped. There are macros in the file, to show the popup list, and to add the selected items to the worksheet cell. DVSP Setup: Use the DVSP tool, you can download the Excel Data Validation Selection Popup (DVSP) Setup workbook. The file is in xlsm format, and is zipped. There are macros in the file, to add the DVSP code to your Excel file. |
Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.
Next, when you get my reply, click the Confirm button. I add this step to protect you from spam!
Data Validation with Combo Box
Last updated: December 27, 2024 11:31 AM