 |
 | 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 / May 2008Quick Find in long drop down list
I would like to be able to type the first few letters in a cell that uses a long drop down list and quickly go to the full name in the list without having to start at the top of the list and scrolling down every time.  SignatureJoe That one I know as one of the good guys answered for me before : get a COMBO BOX from the control box toolbar, give the properties of the cell with the dv and move it on top of it. SignatureSocrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. > I would like to be able to type the first few letters in a cell that uses a > long drop down list and quickly go to the full name in the list without > having to start at the top of the list and scrolling down every time. Sorry, I failed to say I use Excel 2007. I am unfamiliar with combo boxes and could use more detailed instruction. Also my drop down boxes are data validation lists if that makes a difference. SignatureJoe > That one I know as one of the good guys answered for me before : > get a COMBO BOX from the control box toolbar, give the properties of the cell [quoted text clipped - 3 lines] > > long drop down list and quickly go to the full name in the list without > > having to start at the top of the list and scrolling down every time. You can do this with programming, as explained here: http://www.contextures.com/xlDataVal11.html > I would like to be able to type the first few letters in a cell that uses a > long drop down list and quickly go to the full name in the list without > having to start at the top of the list and scrolling down every time. SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html |
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.