 |
 | 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 / September 2007Data Validation with selection
Can Excel 2003 be set up, without VBA, to do Data Validation from a range of cells so that if the person type in the first few letters of the range the pointer moves down the list to those cells to start the selection process? Example of "la" moves to Lanata and doesn't start at Alyssum for the selection. If 2003 does not do this, can 2007 accomplish it? I have looked on Contextures' and J-walk websites without success. Thanks,  SignatureLee Coleman Lee DV has no autocomplete feature. You will have to use a ComboBox to achieve this but it does use VBA so may not be suitable. See Debra's Contextures site for how-to. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP >Can Excel 2003 be set up, without VBA, to do Data Validation from a range of >cells so that if the person type in the first few letters of the range the [quoted text clipped - 4 lines] > >Thanks, Thanks for the response but I am not looking for autocomplete. I would like to type in the first few characters and then press the spinner to have it go to that point in the list rather than the first item in the list. If I typed in "zz" or "300" it would open the list to the nearest group of "zz" or "300" not start at the beginning of the alphabet or numbers. I don't think it can do it but thought I would ask. Thanks again for the response and sorry for not being clearer. Lee Coleman > Lee > [quoted text clipped - 19 lines] >> >>Thanks, You have just described "autocomplete". Re-phrase and re-post if you are not looking for autocomplete. BTW.......there is no spinner attached to a DV list cell.....only a drop-down arrow. Gord >Thanks for the response but I am not looking for autocomplete. I would like >to type in the first few characters and then press the spinner to have it go [quoted text clipped - 28 lines] >>> >>>Thanks, Make that "drop-down arrow" and a scrolbar. Gord >You have just described "autocomplete". > [quoted text clipped - 37 lines] >>>> >>>>Thanks,
|
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.