Marek,

I guess that you must have a forms combobox?

AFAIK there is no way to additem to a forms combo, you have to link to a
spreadsheet range, or change to a control toolbox combo.

--

HTH

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

"Marek " wrote in message
...
here is my code

Sub Button2_Click()
ActiveSheet.OLEObjects("combo1").Object.AddItem "test"
End Sub

clicking button i get error

unable to get Oleobjects property of the worksheet


:(


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