Dropdown fields
 

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


--
pelachrum
------------------------------------------------------------------------
pelachrum's Profile: http://www.excelforum.com/member.php...o&userid=35962
View this thread: http://www.excelforum.com/showthread...hreadid=557708

Dropdown fields
 

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?

Dropdown fields
 

I appreciate it, works really well


--
pelachrum
------------------------------------------------------------------------
pelachrum's Profile: http://www.excelforum.com/member.php...o&userid=35962
View this thread: http://www.excelforum.com/showthread...hreadid=557708