First of all I want to thank all of you that answer and resolve our problems, sometimes I'm really stuck with a problem and often I find a topic with my problem and the right answer. It's awesome...but I have another problem:
I have a Combobox that is used to search a product database with 4 columns (Reference, Description, Quantity and Location) and I want to be able to double click a result (a row) and jump to the worksheet that has a layout of the Location.
I have several Racks (A, B, C...) with the products, and every rack's layout is on a different worksheet with the name A, B, C, D, E, etc... And the location of the products can be B12, A102, C2 (for example, attention this is not a cell reference, it's the product's fisical location reference).
It would be great if the cell with the location reference, in the correspondent layout worksheet, was selected (so it was quicker to see where the location of the product is).
My code (part of it):
Thank you in advance...