Search function code refinement

Hi all,

Im a novice when it comes to macro's VBA etc so I would appreciate some guidance please.

I run a small service department. We have a number of bins containing various parts. Im trying to design an excel sheet that will allow engineers to search for a particular part by description or number and to be shown the relative bin number as a result.

I have searched the net for relevant code and have got pretty close to what I need. However, the search code im using returns the cell reference containing the relevant part number. What I need it to do is return the "bin reference". I have tried naming cell ranges (on the attached example only the first 4 are named) but im unable to modify the button code to return the bin reference as a result.

If anyone could please have a look at my code and let me know what I need to do I would appreciate it.

Thanks

Please Login or Register  to view this content.

Test.xlsm

try

Please Login or Register  to view this content.

Thank you my friend!

That is exactly what I wanted to do....

I do have one small question though, if I may. When a reference is found the messagebox puts the reference on a new line instead of inline (such as the "unable to find" message. Is there a reason for this or can I make them both inline easily?

Thanks again for your help

Try to change this line

Please Login or Register  to view this content.

Thank you again for your help, that has done the trick.

Going back to the original idea, where there is a vertical list of bin references produced, how easy would it be to display the complete data (whole part number, not just the seached part) from the the relevant cell on the same line as the bin reference.

ie so the pop up window looks something like:

Bin Location:
B14: Part number:123555

rather than

Bin Location:
B14

Thanks again, i promise no more questions after this one (not on this subject anyway)

Im trying to understand the code involved in this but it is still somewhat of a mystery

Just append this line

Please Login or Register  to view this content.

Thats exactly what I need.

I would give you more rep but the system wont allow me.

Thanks again for all your help, its really appreciated. Now all I have to do is try and understand how it does it