When the arrow in ComboBox1 on Sheet1 is clicked , a warning message comes up: €œNot enough system resources to display completely.€� The ComboBox has the following properties
LinkedCell: Sheet2!$B$10; ListFillRange: Sheet2!$C$10:$C$1

The following formula correctly populates merged cell range M7:AX7 on Sheet1 €“ in response to the users choice from ComboBox1
=OFFSET(Sheet2!D9,MATCH(Sheet2!B10,{"T1","T2","R1" ,"R2","R3","R4"},0),0

However, clicking €œOK€� in the message box does not remove the message box €“ but going to Sheet2 and then back to Sheet1 clears the message box. Its as though the original appearance of the message box does not do a screen refresh by simply clicking the €œOK€� button

Can someone advise me on the source of the error message, and how to remove the cause? This error is the only thing going wrong in this workbook - as well as any other (MS Office) application

Thanks
Phi