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.