I am working on a small macro that I know I've done before, but for some reason am stumped over.
I have six columns - Part1, Desc1, and Tie, and Part2, Desc2, and Info. (Items/descriptions in Part1/Desc1 will not be repeated in Part2/Desc2.) All data, numerical or otherwise, is treated as a text string.
I have set up an input screen for the user to input part or all of the Part number; the code I want to write will search, first, Part1, then Part2, and display either the tie-hi or the info listed for that part.
End result - when the user opens the workbook, an input box pops up - they key in the part or description information, and a display will come up with the info. They then have the option to close or start a new search.
Key is, the user may know only part of the item number or description, so the search results will include all similar part numbers.
I know the function is fairly simple, but either I'm not wrapping my head around the right information or I'm looking in the wrong direction entirely.
Any help would be greatly appreciated.
I have six columns - Part1, Desc1, and Tie, and Part2, Desc2, and Info. (Items/descriptions in Part1/Desc1 will not be repeated in Part2/Desc2.) All data, numerical or otherwise, is treated as a text string.
I have set up an input screen for the user to input part or all of the Part number; the code I want to write will search, first, Part1, then Part2, and display either the tie-hi or the info listed for that part.
End result - when the user opens the workbook, an input box pops up - they key in the part or description information, and a display will come up with the info. They then have the option to close or start a new search.
Key is, the user may know only part of the item number or description, so the search results will include all similar part numbers.
I know the function is fairly simple, but either I'm not wrapping my head around the right information or I'm looking in the wrong direction entirely.
Any help would be greatly appreciated.