| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do a set a parameter in cell - choose A or B options?
Look in the help index for data validation or goto
http://www.contextures.com/tiptech.html -- Don Guillett Microsoft MVP Excel SalesAid Software "cara8236" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do a set a parameter in cell - choose A or B options?
Look in the Help file for
Create a drop-down list from a range of cells "cara8236" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do a set a parameter in cell - choose A or B options?
Datavalidation,allow list and put
SSTL,ALUM,COPPER in the source box, that will actually give you a dropdown to select from, if you just want to validate against typing something else you need to de-select in cell dropdown from the validation dialogue box note that this is case sensitive, if you don't want that use custom from allow then in the source use =OR(I7="SSTL",I7="ALUM",I7="COPPER") which is not case sensitive all this can be bypassed by copying and pasting other values -- Regards, Peo Sjoblom "cara8236" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
| how do i choose multiple options in a drop down menu in excel? | Excel Discussion (Misc queries) | |||
| why the date convert to number when i choose formulas from options | Excel Discussion (Misc queries) | |||
| Sort (parameter stored in cell) | Excel Worksheet Functions | |||
| parameter query - multiple options | Excel Discussion (Misc queries) | |||
Hybrid Mode
