Varioys methods to achieve this.

Easiest is DataValidationList. Requires no code for operation.

For very good help on DV visit Debra Dalgleish's site.

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


Gord Dibben MS Excel MVP


On Sun, 2 Jul 2006 14:45:21 -0500, pelachrum
wrote:


is excel capable of having fields as drop down menus for selecting
predefined values?