|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-25-2008, 05:34 PM
|
|||
|
|||
|
drop down box
Hi, I know this function was available in the 2003 version however I can not locate it in the new version of Excel. I'm looking for a drop down box but I want to be able to type the first few letters of the word to go to that field. I have a drop down box with over 1200 locations (destinations) however I didn't want to have to scroll thru the whole list? Please help.
|
|
#2
08-26-2008, 04:49 AM
|
||||
|
||||
|
A ComboBox from the Controls ToolBox or on a UserForm will do this.
__________________
Hope that helps. RoyUK -------- For Excel consulting, free examples and tutorials visit my site Check out the free Excel Toolbar New members please read & follow the Forum Rules Remember to mark your questions Solved and rate the answer(s) Where to copy the code to Code Tags: Make your code easier for us to read
|
 |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Making a drop down list conditional | concretetsunami | Excel General | 4 | 04-30-2008 09:46 PM |
| Cell drop down and If formulas | Alsebiates | Excel - New Users | 1 | 11-02-2007 06:15 PM |
| drop down boxes, etc. | jammanex | Excel General | 1 | 04-13-2007 05:33 PM |
| From one drop down to another | derwood | Excel Programming | 5 | 04-09-2007 07:36 PM |
| Drop Down list - is there another way? | pewe | Excel Worksheet Functions | 4 | 02-21-2007 08:20 AM |
Linear Mode
