I have a formula which calculates a customer's favourite shop. The problem is that it's an array formula and, even though I could add it to the worksheet (like I did in the attached workbook), it will take ages till the caluclation is complete. That's because I have over 300 shops and over 3000 customers.
I work a lot with userform and I need to the display the favourite shop in the userform only. Hence I want the calculation to take place in the userform only which would save a lot of calculation time.
This is the formula for F2:
When converted to VBA with the macro recorder, I get the following code:
'.FormulaArray = _
How would you code this with VBA/in a userform? The RC[-1] need to be replaced by listbox1.value.
Can you advise a good website or book on how to write worksheet formulas in VBA for userforms?
Thanks for your help