View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cara8236 cara8236 is offline
external usenet poster
 
Posts: 1
Default How do a set a parameter in cell - choose A or B options?

I have an Excel Spreadsheet. I want to create a form where in a designated
cell - another user can only choose pre-designated options to type into that
cell. How do I do that? Example: Cell A1 - User can choose to type in:
SSTL or ALUM or COPPER. The user would not be able to type any other value
in cell A1.