is excel capable of having fields as drop down menus for selecting predefined values?
P pelachrum Jul 2, 2006 #1 is excel capable of having fields as drop down menus for selecting predefined values?
G Gord Dibben Jul 2, 2006 #2 Varioys methods to achieve this. Easiest is Data>Validation>List. 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
Varioys methods to achieve this. Easiest is Data>Validation>List. 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
