Hi.
I have 30 images in in C:\Users\Public\Pictures\Sample Pictures.
I have a UserForm with 10 controls (image1, image2 ... img 10)
I need to create a way to run the 30 images so aletória controls within the images.
does anyone know how?
Hi.
I have 30 images in in C:\Users\Public\Pictures\Sample Pictures.
I have a UserForm with 10 controls (image1, image2 ... img 10)
I need to create a way to run the 30 images so aletória controls within the images.
does anyone know how?
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Put this code into the FORM module.
When the form initializes, it pulls a list of ALL the JPG files in the given FPATH directory at the top of the page.
Then when you click RANDOM, it creates a list of 10 unique random numbers, then pulls the pictures from the array in those numeric positions and displays them. Each time you click you'll get 10 dif pics. This should eliminate duplicate pictures ever showing.
![]()
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
It was great!!
But I still need more help.
I'll explain in the folder I mentioned will have these 80 pictures named 1-30 and 50 numbered 31-80 who are part of another routine, this routine he has to get the images named only 1-30 and he is taking all the pictures.
The name of each picture is (1, 2, 3 ... 30)
thank you!!!!!!!!!!!!!!!!!!!!
Yeah, I'm going to tell you to put pictures for separate uses into separate folders. That way you can update this by simple adding/removing pics from any one folder.
Hi
i'm very happy
Thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks