How to use the Data Entry Search Popup (DESP) kit from Contextures.
With the DESP kit, you can set up popup lists in an Excel workbook, to quickly and easily select items from a drop down listt. Before you can use the popup list, you must have named ranges set up in your workbook, and drop down lists that are based on those ranges.
Follow the steps in the DESP Get Started guide, and in the DESP Setup workbook, to set up the DESP popup list in your workbook.
This online DESP Guide has additional details, such as making adjustments to the appearance of the DESP forms.
The popup list is a Listbox on a UserForm, which also has 5 buttons – New, Clear, ALL, OK and Cancel. This section explains how to make minor changes to the UserForm’s appearance.
You can adjust the size of the UserForm, or the controls. For example:
To adjust the size of the UserForm:
To adjust the size of a control:
To adjust the font type or size of a control:
To change the text on a button:
If you run into any problems, please check the Frequently Asked Questions page. If you can't find an answer there, please contact me (Debra Dalgleish) by email. I'm in the Toronto time zone (Canada), and will reply as soon as possible:
ddalgleish @ contextures.com
Last updated: April 16, 2021 2:49 PM