View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KBrenner KBrenner is offline
external usenet poster
 
Posts: 7
Default User Form will not scroll to Match Entry First Letter?

I created a Userform with a listbox link to a list. When I orginally create
the userform, I use to be able to type the first letter and the listbox would
scroll to the first letter that I typed. Now it will not scroll to anything,
I have to use the mouse to get to the item in the list and if I have more
than 200 items to select from this is a pain. I Select the 0 -
fmMatchEntryFirstLetter in the ListBox Properties but it did not work!
I have tweak with every Property in the ListBox (Ithink!) but cant make it
work!
Is ther a secret or something in one of the fields in the worksheet with the
data list.

Thanks for your help!

K. Brenner