I have create a combbox using toolbarsControl Toolbox. (not used User Form)
I can populate it by altering ListFillRange in properties. What i actually
need to do is, using code i want to populate combobox with a range on a
second sheet E.G Sheet2 range A1:A10 but ommiting any blank cells in this
range.

Is this possible? Not used comboboxs before!

Please help in newbie talk!

Sunil