LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 53
Default Finding the first instance of a name or partial name in a list of names

I have a worksheet with about 1500 names and addresses in it.... one contact
per line.
All the names are in cloumn B.
What I want is a macro that will display an input box to get the name that I
want to find in the list. When the user types in the name I want the screen
to display that person's line in the list (database). I'd like to be able
to enter a minimum of 1 letter... "M" for instance and have it select the
first name beginning with "M". Sometimes I might enter more letters
though. So it need to match whatever is entered in the input box.

I know this can't be too hard, but I've messed around too long trying to get
something to work and am getting nowhere.

Any help would be greatly appreciated.

Jon


 
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
Finding a name with partial description and deleting all occurrenc pm Excel Worksheet Functions 1 March 25th 09 01:30 AM
FINDING PARTIAL ENTRIES IN A CELL/ARRAY FARAZ QURESHI Excel Discussion (Misc queries) 1 January 29th 09 12:06 AM
Finding the highest alphabetic name in a list of names s Excel Worksheet Functions 10 December 20th 06 10:10 PM
Sumproduct and finding partial strings Jeff Excel Programming 4 January 6th 05 04:29 PM
Finding Partial Text in a Cell bob Excel Worksheet Functions 6 December 18th 04 05:03 AM


All times are GMT +1. The time now is 12:03 AM.

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

About Us

"It's about Microsoft Excel"