ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   go to a specific letter in a list (https://www.excelbanter.com/excel-worksheet-functions/130886-re-go-specific-letter-list.html)

Toppers

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




All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com