View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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