Excel for mac 2011 data labels from range series

Now as i got the list in the ComboBox, When I select a value from the ComboBox, for example, it should reflect in the Cell A1.

Let me explain the second question in detail.

I’m creating a general OLEObject even though I specify the class. I set some other properties like Value to start with them all unchecked, LinkedCell so I can test the cell value later when I hide rows, and Caption because a caption would be superfluous.

This will cover the entire cell and hide the TRUE and FALSE from linking the checkbox.