View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default go to a specific letter in a list

Use the Combo box from the "Control Toolbox " toolbar and in Properties
(right click on Combo box) set ListFillRange to your data list.

Type in (start of) name and you will get full name.

HTH

"Petya" wrote:

Dear All,
i have a list created, with a lot of customers (its a dropdown list, where
you can roll to the desired customer). Is it possible to do the following: if
i start to write in the customer name; (let's say Hilton), than at Hi it
gives me the Hilton name already (of course if there is no more with Hi start.
I hope it is clear:-)

thx a lot
Peter