Drop Down List
 

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)?

Drop Down List
 

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)?

Drop Down List
 

"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)?

Try Debra's vintage, starting at:
http://www.contextures.com/xlDataVal01.html
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---