Thank you NoSparks!! Very helpful

Correct me if I'm wrong, my understanding of what you've said is:


1) Start a new worksheet in the same workbook, say its called "Backend"

2) Put a formula in a cell, say C1, and that formula should be
= 'Price Calculator'!$A$11

3) Change your code where it says:
If Range("A11") < 2 Then
To If Range("C1") < 2 Then

4) Paste this code onto the "Beckend" worksheet, and NOT the "Price Calculator" worksheet

If I have understood you correctly, what would the code call the combo boxes??

Would they not have to be referenced to the "Price Calculator" worksheet??



PS I have tried your code exactly as it is straight into the worksheet coding, and it works a treat but would still like the above guidance if poss!!!!