Setting combo box index

[CoolCyber]

Hi,

I am trying to set the index value of a combo box in excel spread sheet. but
it gives a error saying need ":="

i am giving as
Sheet2.cboxActivity.AddItem("Name", 1)

Do i have to do something else?

Prn

[mooncrawler]

What if you remove the ()

Sheet2.cboxActivity.AddItem "Name", 1



"CoolCyber" <[email protected]> schreef in bericht
news:[email protected]...
> Hi,
>
> I am trying to set the index value of a combo box in excel spread sheet.
> but it gives a error saying need ":="
>
> i am giving as
> Sheet2.cboxActivity.AddItem("Name", 1)
>
> Do i have to do something else?
>
> Prn
>