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) |