Hello,
I am using the value selected in a combobox as a sort of filter, as in
If Range("A1")=ActiveSheet.OLEObjects("ComboBox1").Object.Value Then
Range("B1") = Range("A1").value/ ActiveSheet.OLEObjects("ComboBox1").Object.Value
However if ActiveSheet.OLEObjects("ComboBox1").Object.Value is...