Excel Combo Box & Web Service

[Athan]

Hello

How can I load the values from a web service to combo box in excel ?
The web service returns a dataset with ID and TEXT

Thank you

Athan

 

[Tom Ogilvy]

define returns.

Is it held in an array. Is it placed on a worksheet. It is stored in a
file?

 

[Athan]

The dataset is held in an array,

I don't know how to place it on a worksheet, and bind it to the combo box

Thank you

Athan

 

[Tom Ogilvy]

assume the array name is v

lb1 = lbound(v,1)
lb2 = lbound(v,2)
ub1 = ubound(v,1)
ub2 = ubound(v,2)
set rng = range("A1").Resize(ub1-lb1+1,ub2-lb2+1)
rng.Value = v
ActiveSheet.Combobox1.ListFillRange = rng.Address(external:=True)