Prev: VBA--Suppress error message,corrupt file or unrecognizable format
Next: How to prevent "Private Sub Workbook_SheetSelectionChange" to execute when a certain sub is executed ?
From: rakowd on 18 Dec 2009 15:24 I'm using Excel 2007. I have a range of items that are set up as a list. In the column where I select from the list my drop down box does not allow me to put in a character such as "R" then go to that group of names. How do I set this up so that I do not have to scroll down the complete list before getting to the "R's". tx
From: Paul C on 18 Dec 2009 15:35
This recent thread may help http://www.microsoft.com/office/community/en-us/default.mspx?&lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.excel.misc&p=1&tid=5f38e38f-8dd7-41e8-9bd4-484964a8d0c4&mid=9df678e3-a472-434b-a60d-1500d2f1af63 -- If this helps, please remember to click yes. "rakowd" wrote: > I'm using Excel 2007. I have a range of items that are set up as a list. In > the column where I select from the list my drop down box does not allow me to > put in a character such as "R" then go to that group of names. How do I set > this up so that I do not have to scroll down the complete list before getting > to the "R's". tx |