INDEX MATCH Error

Hello Excellers,

Can you help me understand and resolve what's wrong with the following code? Sometimes, it does work but then after one or two test, I get this 1004 error message 'Unable to get the Match property of the WorksheetFunction class'.

It is a vba in a form to search the value of the textbox1 (which is a shorthand ISO CODE of the corresponding value in the combobox1), based on the value given in the combobox1.

Please Login or Register  to view this content.

My form has 2 combo boxes and 1 text box.
The Combobox3 has a category value, the second, Combobox1, has a dependent value, based on the Combobox3 and the listbox1 just vlookup for the corresponding shorthand code for the value in Combobox1

Example: ComboBox3: Bank / ComboBox1: NatWest / ListBox1: NW

Thank you very much for any of your advices, suggestions or helps and your contribution is much appreciated.

The error message only appears when I change the value within the combobox3, which is the category list. Is there any connection here?