Form Controls on Excel worksheet
 

Hello,

can I use an array as input range for a (form) combo box ?

Kind regards,

H.G. Lamy

Form Controls on Excel worksheet
 

You have to manuall in code use Additem to put each item of an array
into a combobox


for i = 0 to Ubound(MyArray)

Listbox1.additem MyArrray(i)

next i


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=170371

Microsoft Office Help

Form Controls on Excel worksheet
 

Thank You !

H.G.

"joel" wrote in message
...

You have to manuall in code use Additem to put each item of an array
into a combobox


for i = 0 to Ubound(MyArray)

Listbox1.additem MyArrray(i)

next i


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=170371

Microsoft Office Help