pass array or list to sub routine

[tim_p]

Hi all im trying to pass a listof numbers to a subroutine to then loop through them so far ive got the sub but i cant seam to work out how to call it i would like something like

Please Login or Register  to view this content.

heres the sub

Please Login or Register  to view this content.

Kind regards tim

[sintek]

Hi Tim...
What are you wanting to achieve...
I suggest uploading a sample file and explain in detail what you are trying to achieve...See top yellow banner
I am assuming you want to populate ComboBoxes 2,4,7 & 9

Please Login or Register  to view this content.

[tim_p]

hi yes thats correct i wish to populate the comboboxes there are qute a few so rather than writing

Please Login or Register  to view this content.

for every control i would like to loop through them im just not sure on pass an array which would be the combobox id number to my subroutine it doesent need to return a value

Kind regards tim

[jindon]

Do you mean like this?

Please Login or Register  to view this content.

heres the sub

Please Login or Register  to view this content.

[tim_p]

Hi thanks

thats what im hoping for but i get a type missmatch

Thanks tim

[jindon]

Try change to

Please Login or Register  to view this content.

[tim_p]

fab

thanks