View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Entering data from dropdown list

Seems to me you are talking about a worksheet, not a form. Is it Data
Validation you are looking for?

Data|Validation-List

Note: if your list is in another worksheet, you need to first name it.
Select the list, Insert|Names|Define, give it a name, e.g. DataList.
Then use this name in the Data Validation dialog box.

HTH
Kostis Vezerides