Excel Combobox: Could not set the ControlSource property

Hi everyone!

Every time I try to set the ControlSource property I recieve "Could not set ControlSource property. Invalid property value".

Code Snippet

ComboBox1.ControlSource = "B1"

What is wrong? Maybe I've missed some necessary options?

[413 byte] By [Mezhick] at [2008-1-10]
# 1

Hi!
Do you use a combobox of a sheet or a form?
Combobox of a sheet don't have such property (at least in Excel_2003)

And do you do this in C#?

bi-lya at 2007-10-3 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...