Hi
as a starting point:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany


ssb wrote:
Hello,

Say, I have column called "Employee Designation" in a excel 2k
spreadsheet. This spreadsheet kind of plays the role of a simple
form.

Everytime a user updates the spread sheet for a new row, I want the
cell under "Employee Designation" column to appear as a drop down
list.

In fact, whevever a user has to choose between a fixed set of values
for a given cell, I would want a drop down list to appear.

How do I go about it..??

thanks for the help.