DataValidationList.

For more information and instructions on how to set this up, see Debra's site.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP

On Thu, 24 Jan 2008 12:23:42 -0800, Matt wrote:

How can I create a drop down list in a field? For example, I would like to be
able to click on Field A1 and a drop down list pop up asking me what
preselected information I would like to select, like (name, date, time, etc)?