Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Search and Match Values

I am trying to avoid having to scroll through an existing ListBox to find a
name. The existing ListBox references a column/list of names within a
database.

I would like to have a user find a name within the ListBox by entering the
"name" into a TextBox, which then finds the ExactMatch name in the referenced
ListBox.

If there is an ExactMatch, Then the "name" in the ListBox is highlighted or
selected.

I would greatly appreciate your assistance with this.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Search and Match Values

You can do that, but why would you want to when you can just as well work
right from the text box? Iif the user types the name in and presses enter,
you could write the code to do the same thing that the listbox does if the
name is selected there.

"CROD" wrote:

I am trying to avoid having to scroll through an existing ListBox to find a
name. The existing ListBox references a column/list of names within a
database.

I would like to have a user find a name within the ListBox by entering the
"name" into a TextBox, which then finds the ExactMatch name in the referenced
ListBox.

If there is an ExactMatch, Then the "name" in the ListBox is highlighted or
selected.

I would greatly appreciate your assistance with this.


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
Match formula to match values in multiple columns K[_2_] Excel Discussion (Misc queries) 2 April 22nd 10 10:22 AM
how can we get unique values in match function for same match key. Xcel[_2_] Excel Worksheet Functions 11 December 7th 07 08:13 PM
Search Column, If match found then add two values. [email protected] Excel Programming 2 March 21st 07 09:33 AM
How to Search, Count, Match and Post Values vincentws Excel Worksheet Functions 4 August 17th 06 05:20 PM
Search/Filter to find values in another range based on two cell values Andy Excel Programming 2 April 29th 04 04:08 PM


All times are GMT +1. The time now is 04:39 PM.

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"