Greetings mrexcel users,
Wondering if someone can share their knowledge of vba with the index match function. I am confident with the index match function at worksheet level but am really struggling with vba-
I am creating a userform (UserForm1) which requires users to select a vaue from combobox "Product number" (cmbProd) and enter a value into text box "Label Trace code" (txtLab)- Note- the value in text box txtlab uses Numbers and "." example (ET.475.2028)
When the user has entered this data they will click the button check (cmdCheck)
On (cmdCheck) i want the userform to check and match the data entered in (cmbProd) and (txtLab) with a table (TableProd) in a worksheet (Lookups) from (column C and D) and return either "Pass" if exact match or "Fail'' if no match in text box "Result"(textRes1)
Please forgive me if this is a simple task to achieve- perhaps not even requiring the use of the index match function. i have spent hours upon hours trying to figure this out and to find an answer on the internet is impossible
Thanks in advance to anyone who is able to provide support.
Wondering if someone can share their knowledge of vba with the index match function. I am confident with the index match function at worksheet level but am really struggling with vba-
I am creating a userform (UserForm1) which requires users to select a vaue from combobox "Product number" (cmbProd) and enter a value into text box "Label Trace code" (txtLab)- Note- the value in text box txtlab uses Numbers and "." example (ET.475.2028)
When the user has entered this data they will click the button check (cmdCheck)
On (cmdCheck) i want the userform to check and match the data entered in (cmbProd) and (txtLab) with a table (TableProd) in a worksheet (Lookups) from (column C and D) and return either "Pass" if exact match or "Fail'' if no match in text box "Result"(textRes1)
Please forgive me if this is a simple task to achieve- perhaps not even requiring the use of the index match function. i have spent hours upon hours trying to figure this out and to find an answer on the internet is impossible
Thanks in advance to anyone who is able to provide support.