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: 186
Default Selection based on partial input

I'm developing in Excel 2003

i have a workbook with two worksheets.
Sheet 1 needs to be the data input
Input Account number
Display Account Name

Display list of data from Sheet 2 as Account number is input
- based on up to the first 3 characters entered.

Sheet 2 has four columns of data
A - Account Number (this is a text field)
B - Account Name
C - Group Name
D - Location

------------------------------------------------------------------------
Data Sample

10117 Company 1 Software South
10120 Company 2 Hardware East
10225 Company 3 Software North

As the account number is entered the above list would display starting in
row 10. By the time 102 is typed the list would reduce to just the last item.

A user could select an account from the displayed list using the up / down
arrows or mouse and enter and the input would be completed.

I stuck on getting the list to display as the data is being typed. Any help
will be appreciated





 
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
Selection based on partial input affordsol Excel Programming 7 March 17th 08 07:59 AM
sum if based on PARTIAL content of another cell [email protected] Excel Worksheet Functions 1 April 6th 07 05:19 AM
sumif based on partial match [email protected] Excel Worksheet Functions 2 April 4th 06 01:14 AM
Partial input Brad Excel Discussion (Misc queries) 4 October 21st 05 03:31 PM
Macro to change list box input range based on selection made in another cell Sue[_6_] Excel Programming 3 October 7th 04 06:45 PM


All times are GMT +1. The time now is 01:47 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"