Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selection based on partial input | Excel Programming | |||
sum if based on PARTIAL content of another cell | Excel Worksheet Functions | |||
sumif based on partial match | Excel Worksheet Functions | |||
Partial input | Excel Discussion (Misc queries) | |||
Macro to change list box input range based on selection made in another cell | Excel Programming |