View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Predefined text list

hi
data validation.
on the menu bardatavalidation
from the first dropdown select list
from the second dropdown enter the list address.
on the other tabs, you can enter an input message and/or a warning message.

Regards
FSt1

"Mel" wrote:

I need to set up predefined text lists and then link them to certain cells
and limit the entry in that cell to the predefined list - how do I do this???