Home > Validation > Drop Downs > Popup

Data Validation Select Popup Tool

With 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.

Excel drop down list types

Author: Debra Dalgleish

Select Single or Multiple Items

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.

select a single item from the list

Multiple and Dependent Selections

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:

  • Canada was selected as the Region, in column E
  • In column F, there is dependent data validation
  • The popup only shows cities for the selected region

multi select listbox

Video: Watch the DVSP Demo

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.

  • 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".

Video: How to Use Setup File

Next, watch this video to see the DVSP setup file steps, and there are written instructions in the Setup file.

customize the code

Excel Skills Needed

To use the DVSP tool, 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 a named range -- there are instructions and a video here: Create a Drop Down List

DVSP - Important Notes

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.
  • Always make a backup copy of your Excel file, before adding the DVSP tool.
  • Later, make a backup copy of your Excel file, before making any changes to the DVSP code or setup
  • The DSVP tool is designed for workbooks that do not have any existing macros on the worksheet code modules. 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.

DVSP Help Pages

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:

-- Data Validation Multi-Select Popup page

-- DVSP User Guide page

-- 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 Files

DVSP 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..

Related Links

Naming Ranges

Worksheet Combo Box Macros

Data Validation Drop Downs

 Dependent Drop Down Lists

Data Validation with Combo Box

 

 

Last updated: February 16, 2024 3:38 PM