 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Pb with Data validation based on named list
Hello, I create a Name as Test = {"A" , "B"} (not a range but a list of datas) by the menu 'Insert" / "Name" / "define" Then i cant'use that name "Test" in the Data validation Combo box by the menu "Datas" / "Validation" / "Option" / "Autorize" (List) The error message is that system does'nt accept in "Source" = Test Where is the Probleme thanks for your help Gilles PROVOST Hi Gilles You don't need the named range. In Data Validation>List>Source>A,B No need for the = sign before your list of values, just a comma (or ; if that is your Regional separator) between each item you wish to allow.  SignatureRegards Roger Govier > Hello, > [quoted text clipped - 10 lines] > > Gilles PROVOST Thanks for this way of solution but,... I need to have an defined name for the drop-down list items because i re-use this name in a MATCH() function in others range of the worksheet. Regards, Gilles > Hi Gilles > [quoted text clipped - 18 lines] > > > > Gilles PROVOST Hi Gilles Then try placing the values you want in cells A1:A2 of Sheet2and name Test as Sheet1!A1:A2 SignatureRegards Roger Govier > Thanks for this way of solution but,... > I need to have an defined name for the drop-down list items because i [quoted text clipped - 26 lines] >> > >> > Gilles PROVOST Apologies, that should have read Then try placing the values you want in cells A1:A2 of Sheet2 and name Test as =Sheet2!A1:A2 SignatureRegards Roger Govier > Hi Gilles > Then try placing the values you want in cells A1:A2 of Sheet2and name Test [quoted text clipped - 31 lines] >>> > >>> > Gilles PROVOST Hey, Really sorry to insist on it, By my target is to avoid a new sheet only for store two datas.... However Thanks for your answers Gilles > Apologies, that should have read > [quoted text clipped - 36 lines] > >>> > > >>> > Gilles PROVOST Gilles You don't have to use another sheet. Use any spare cells on your existing sheet. There is no problem in using another sheet, however, it can be hidden if you wish. SignatureRegards Roger Govier > Hey, > Really sorry to insist on it, [quoted text clipped - 48 lines] >> >>> > >> >>> > Gilles PROVOST |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.