ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,737
- Office Version
- 2007
- Platform
- Windows
I’ve been looking for a code this evening without any luck.
On my worksheet called SHEET1 in column A is a list of customers names.
I need to be able to search for a certain customer where I have limited information on them & be able to select them from a list box.
It would work something like this.
I would have a list box which would have a search field & below it a space for the returned names.
So I type some partial info that I know in the search field & press the search button.
In this case let’s say SMI
The code would look down column A and return any name that has SMI in it & place it in the list box.
Lee SMIles
Abdul aSMIn
SMIley miley
So I now have say 3 possible customers shown in my list box.
Clicking on the name would then take me to the row that customer is in.
In this case Abdul aSMIn & the cell A258 is selected.
On my worksheet called SHEET1 in column A is a list of customers names.
I need to be able to search for a certain customer where I have limited information on them & be able to select them from a list box.
It would work something like this.
I would have a list box which would have a search field & below it a space for the returned names.
So I type some partial info that I know in the search field & press the search button.
In this case let’s say SMI
The code would look down column A and return any name that has SMI in it & place it in the list box.
Lee SMIles
Abdul aSMIn
SMIley miley
So I now have say 3 possible customers shown in my list box.
Clicking on the name would then take me to the row that customer is in.
In this case Abdul aSMIn & the cell A258 is selected.
