Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation
hey how's it going?
look, i have created my data validation with a list, it is a list of customers and vendors, but i would like, when i type the first letter, it shows me all the data that i have with that letter, i hope it is possible, and i hope also you can help me. about the validation too, i would like, in my validation drop drown list, i would like a caracter that says, " add new" so that way when o want to create a customer or a vendor, it shows me a window or something to create the new caracter, i do not know if that is possible too. thank you for all your information granted. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation
For the autocomplete, you would need a ComboBox
See Debra's site for this. http://www.contextures.on.ca/xlDataVal10.html For the add new items query see Debra's site at http://www.contextures.on.ca/excelfiles.html#DataVal DV0038 - Flexible Item List -- Use formulas to automatically add new unique items to a data validation dropdown list. Sample file from Ron Coderre. DataValFlexList.zip 7kb Download Ron's sample file. Gord Dibben MS Excel MVP On Mon, 28 Jan 2008 10:47:00 -0800, Morfeo wrote: hey how's it going? look, i have created my data validation with a list, it is a list of customers and vendors, but i would like, when i type the first letter, it shows me all the data that i have with that letter, i hope it is possible, and i hope also you can help me. about the validation too, i would like, in my validation drop drown list, i would like a caracter that says, " add new" so that way when o want to create a customer or a vendor, it shows me a window or something to create the new caracter, i do not know if that is possible too. thank you for all your information granted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |