ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to write in a dropdown data(Validation) (https://www.excelbanter.com/excel-discussion-misc-queries/252234-how-write-dropdown-data-validation.html)

[email protected]

how to write in a dropdown data(Validation)
 
Please how can i make a data validation (dropdown list) so that the
user can type in something if what he/she is looking for is not
there? I'm using Excel 2003 but if there is an easy way in 2007 I
will like top know.
THANKS

Don Guillett

how to write in a dropdown data(Validation)
 

xl2003
in the error alert uncheck or use warning instead.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Please how can i make a data validation (dropdown list) so that the
user can type in something if what he/she is looking for is not
there? I'm using Excel 2003 but if there is an easy way in 2007 I
will like top know.
THANKS



[email protected]

how to write in a dropdown data(Validation)
 
On Jan 2, 6:19*am, "Don Guillett" wrote:
xl2003
in the error alert uncheck or use warning instead.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

...



Please how can i make a data validation (dropdown list) so that the
user can type in something if what he/she is looking for is not
there? *I'm using Excel 2003 but if there is an easy way in 2007 I
will like top know.
THANKS- Hide quoted text -


- Show quoted text -


Thanks Don I've got it now


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com