Check if combobox has assigned value

[always_confused]

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 not assigned, I'm dividing by nothing and that doesn't work. I have tried a bunch of combinations of Is Null, is Nothing etc, and I cannot figure out how to check if the value has been selected in the combobox before dividing by it.

Can anyone help me with the syntax here?
Thanks

 

[Zot]

When you created an ActiveX (ComboBox in this case), the default assigned name is ComboBox1, subsequent one will be ComboBox2, ComboBox3 and so on. This is shown in Name Box (the box left to the formula bar) when you select the ComboBox in Design Mode (for example).
You can simple refer to the object by its name just like this
ComboBox1.Value -- will give the value selected. If nothing is selected, I believe it will just be blank.

Let say you refer to a range for drop down value and it is number 1, 2, and3.
Range("A1") = ComboBox1.Value
will results in "1" (text) if number 1 is selected, but I believe it will still converted to number by Excel if you put say
Range("C1") = 3 / Range("A1")

You can check if ComboBox has any value using
If Not Len(ComboBox1.Value)=0

 

[always_confused]

When you created an ActiveX (ComboBox in this case), the default assigned name is ComboBox1, subsequent one will be ComboBox2, ComboBox3 and so on. This is shown in Name Box (the box left to the formula bar) when you select the ComboBox in Design Mode (for example).
You can simple refer to the object by its name just like this
ComboBox1.Value -- will give the value selected. If nothing is selected, I believe it will just be blank.

Let say you refer to a range for drop down value and it is number 1, 2, and3.
Range("A1") = ComboBox1.Value
will results in "1" (text) if number 1 is selected, but I believe it will still converted to number by Excel if you put say
Range("C1") = 3 / Range("A1")

You can check if ComboBox has any value using
If Not Len(ComboBox1.Value)=0