Data in combobox

sathishr · January 2nd, 2007, 03:58 AM

Hai all,
I need to add data in combobox at runtime.that is i need to add data by typing in combobox.can anybody help me to do this.

thanks
sathish

vemaju · January 2nd, 2007, 06:35 AM

Hi,

If you use ActiveX ComboBox then use AddItem Method

ComboBox1.AddItem "Item1"
ComboBox1.AddItem "Item2"
...

If you use Forms Control ComboBox then
Worksheets(1).Shapes("Drop Down 1").ControlFormat.ListFillRange = "A1:A10"

-vemaju