Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I count cells beginning with specific letter? jay New Users to Excel 7 October 15th 08 06:25 PM
go to a specific letter in a list Petya Excel Worksheet Functions 0 February 15th 07 03:13 PM
replace letter of alfanumeric value by a specific number El Criollo Excel Discussion (Misc queries) 1 December 7th 06 01:09 PM
how do i sort a list from cells by picking a specific letter? abecus Excel Discussion (Misc queries) 2 July 4th 06 02:47 PM
Formula for cells that contain a specific letter carrielu Excel Worksheet Functions 5 April 14th 06 02:42 PM


All times are GMT +1. The time now is 11:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"