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" <coolcyber+microsoft@gmail.com> schreef in bericht
news:uJ$Vwnl2FHA.1700@tk2msftngp13.phx.gbl...
> 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
>