Workbook_SheetChange not triggered by Combobox

[ron2k_1]

Hey guys,

I have this code, which pretty much change each other depending on the selection of B1:B3 on any sheet:

Please Login or Register  to view this content.

B1 of both sheets however, is a linked cell to ComboBox1 which exists on both sheets. When I change ComboBox1 on "Comparison Detail" it updates B1 of both sheets. When I make a selection on Combobox1 of "Comparison Summ", it changes B1 of that sheet but not on "Comparison Detail".

Am I missing something guys?

Thanks,

Ron


EDIT: Actually guys, it seems that the change done by the combobox1 is not seen as a workbook change. What can I do in this case guys? Both worksheets are full of formulas that depend on B1. And I'm using a Combobox because it has a code attached to it.

[ron2k_1]

Well, I did this and it seems to work:
I changed the above code to this:

Please Login or Register  to view this content.

And then added this private code to each of those worksheets:

Please Login or Register  to view this content.

Of course I changed the sheet name on the other worksheet for the B1 reference thing.

Thanks thou