View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jack jack is offline
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