Multiple images in userform

[KUYJS]

Hi, i have one user form which has 10 image boxes or image controllers. I want to run a loop to upload pictures to these image boxes.
How to so that?

Image1.picture = Loadpicture(imagepath)

i am not able to place i (where i = 1 to 10) as
Image i.picture = Loadpicture(imagepath i)

please help

 

[My Aswer Is This]

Show us the script you use now to load images one at a time not using loop.

 

[KUYJS]

Currently i am doing it one by one like:

Image1.picture = Loadpicture(imagepath1)

Image2.picture = Loadpicture(imagepath2)

and so on...

 

[My Aswer Is This]

I do not believe your path to the image would be

imagepath

Most file path's would look like: "C:\Users\owner\Documents\TestMe Now.xlsm"

Or something like that.<strike></strike>
​

 

[My Aswer Is This]

And I asked to see your script. You did not show me a script.

 

[KUYJS]

Hey,

I haave already shared the script as below:
Image1.picture = Loadpicture(imagepath1)

i have defined imagepath as string and have stored image path address to it. The way i showed it here is working perfectly fine.

My question is, instead image1.picture, can i use image i.picture. Where i is variable (integer) and will vary from 1 to 10. Ex:

For i = 1 to 10
Image i.picture = Loadpicture(imagepath i)
Next i

So that when i =1
Image1.picture = Loadpicture(imagepath1)
when i =2
Image2.picture = Loadpicture(imagepath2)

and so on...

Hoe this clarified my question

 

[Jaafar Tribak]

Hey,

I haave already shared the script as below:
Image1.picture = Loadpicture(imagepath1)

i have defined imagepath as string and have stored image path address to it. The way i showed it here is working perfectly fine.

My question is, instead image1.picture, can i use image i.picture. Where i is variable (integer) and will vary from 1 to 10. Ex:

For i = 1 to 10
Image i.picture = Loadpicture(imagepath i)
Next i

So that when i =1
Image1.picture = Loadpicture(imagepath1)
when i =2
Image2.picture = Loadpicture(imagepath2)

and so on...

Hoe this clarified my question

You could use the controls collection like this :

Me.Controls("image" & i)

 

[KUYJS]

Hey Jaafar
Thank you so much, this worked perfectly the way i wanted.

You are a CHAMP