force a selection from a list of words
Use Data Validation
--
Gary''s Student - gsnu200766
"Rick S." wrote:
I have a list of prefered words for specific type work sheets, is there a way
to force a user to select from that list and only that list?
In my workbooks, each sheet will have a column (F) that will use up to 29
rows maximum. When ever a user selects a cell in that column I want to force
them to select from a list of specific words to fill the cell.
--
Regards
VBA.Noob.Confused
XP Pro
Office 2007
|