activesheet.oleobjects("combo1").object.additem "test"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Marek " wrote in message
...
people i cant add items to the combobox,

i have sheet.name = s1
and on the sheet i have control placed combobox,
combobox name is combo1


in vb editor i write this text

worksheets("s1").shapes.item("combo1").additem "test"

but vb gives me error like = cant find object ???


how to correctly work with sheet controls from vb ?


thanks


---
Message posted from http://www.ExcelForum.com/