Excel Combo Box & Web Service
 

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

Excel Combo Box & Web Service
 

define returns.

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

--
Regards,
Tom Ogilvy

"Athan" wrote in message
...
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

Excel Combo Box & Web Service
 

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" wrote in message
...
define returns.

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

--
Regards,
Tom Ogilvy

"Athan" wrote in message
...
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

Excel Combo Box & Web Service
 

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)


--
Regards,
Tom Ogilvy

"Athan" wrote in message
...
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" wrote in message
...
define returns.

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

--
Regards,
Tom Ogilvy

"Athan" wrote in message
...
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