Complile Error: Method or data error not found

[mregan]

My AR person is getting a compile error and can't figure it out. I'll be upfront and say this is way over my head and I'm an excel novice so I apologize up front if my explanation and excel terms aren't correct. We have a multi sheet sales workbook for our salesmen. The first sheet is if we are selling Equipment A, 2nd sheet if selling Equipment B etc. My AR person created a drop down so when the salesmen start typing in the equipment model number, it shows all the equipment that start with those letters, then can then select which piece of equipment and it fills it in. I'm pretty sure she found the code online and tweaked it to work for what we wanted. It works perfectly on the first sheet for Equipment A. She copied the code to do the same on the Equipment B sheet but is getting the below error. She can't seem to figure out what the issue is. Any help would be appreciated.

 

[RoryA]

The sheet where the code works has an activex combobox on it called tempcombo. The sheet where the code doesn't work, does not have that control, hence your error.