Using .Find

Hello, I was wondering if anyone could help me wih this:

Please Login or Register  to view this content.

I keep getting an error that says "Object Doesn't Support This Property Or Method")

I am trying to find the value from ComboBox1 in the 'Metallize' worksheet. I could also just search through the columns in the first row, but I don't know how to designate the range for that
Any help would be greatly apreciated. Thanks in advance!

Try

Please Login or Register  to view this content.

Now it is simply returning a blank msgbox. When I set equal to the find statement, is it setting it equal to the cell that it's supposed to find?

Well, now at least the find function is working. I have no idea how combo box work, so the find function might not picking the value from combo.

Ok, thank you for your time. Is there anyone who does know how a combobox would work in this situation?

That Find Statement still is not working anyways though. I have tried to find a simple integer (10) and replace it with another integer (5) and it is not doing this. Any idea why?
Thanks in advance

Can you upload a sample workbook, there are a few problems I could think this might be depending on how it is set up. Is the combobox part of a userform? or the worksheet?