MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Drop down list

Posted by Rick on January 08, 2002 9:45 AM

Is there a way to have an item in a drop down list appear automatically just by entering the first letter of the word?

Posted by Andy Gee on January 08, 2002 10:03 AM

Only if there is no break between the list and the cell. You could hide this list an say a1 to a20

Posted by Rick on January 08, 2002 10:48 AM

Thanks Andy Gee. There is no way to have that happen if the list is in a different area or on a different worksheet?