| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validating Cell
Hi
Does anyone know how I can validate a cell so that it can only take two values "Buy" or "Sell"? It would be even better if the user can select it from a menu or a drop down list. Regards Zak |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validating Cell
Zak, data, validation, allow list, type in Buy,Sell
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "ZAK" wrote in message ... Hi Does anyone know how I can validate a cell so that it can only take two values "Buy" or "Sell"? It would be even better if the user can select it from a menu or a drop down list. Regards Zak |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validating Cell
Many Thanks
-----Original Message----- Zak, data, validation, allow list, type in Buy,Sell -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "ZAK" wrote in message ... Hi Does anyone know how I can validate a cell so that it can only take two values "Buy" or "Sell"? It would be even better if the user can select it from a menu or a drop down list. Regards Zak . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validating a Cell | Excel Worksheet Functions | |||
| validating | Excel Discussion (Misc queries) | |||
| Validating certain cell | Excel Worksheet Functions | |||
| validating | Excel Worksheet Functions | |||
| Validating | Excel Discussion (Misc queries) | |||
Hybrid Mode
