ComboBox Value Comparison from multiple worksheets

[Ed P]

I am resubmitting this from early this morning. I posted this at 6:52 PST
this morning so if someone is working this I apologize.

Can someone please guide me in the right direction on how I would compare the
value of comboboxes from multiple sheets.
I have tried different methods like activating individual sheets but nothing
has worked.
The catch here is that the code needs to run automatically and from a
worksheet that does not contain one of the comboboxes that i am trying to
compare.
Any Suggestions?
Thanks for yuor help
Ed

[Leith Ross]

Hello Ed,

To compare the values of ComboBoxes on diffrent sheets you need to use a fully qualified object reference. The example below will makes this clear.

Eample - Compare ComboBox1 Value on "Sheet1" to ComboBox2 Value on "Sheet2"

If Sheets("Sheet1").ComboBox1.Value = Sheets("Sheet2").ComboBox2.Value Then
MsgBox "Values are equal"
Else
MsgBox "Values are unequal"
End If

Prefixing the ComboBox with the sheet name tells VBA which ComboBox you want without having to activate the sheet it is on.

Hope this helps,
Leith Ross