How to do a macro in Excel with random pics?

Closed
umbur - 20 Sep 2017 à 06:05
 Blocked Profile - 20 Sep 2017 à 16:32
I need to do a macro with random pics.
When in column "K" in scheet "SHEE4" find word "OK" then replace or paste in next cell random image from folder1.
When in same column find "NA" then replace or paste in next cell random image from folder2.
Related:

1 response

Blocked Profile
20 Sep 2017 à 16:32
This is some kind of homework or something! We do not do homework! This has no real application in the business world, and is a proof of concept!

I will help you out in your journey, how does the spreadsheet know what the VALID names are to be, if they are random? You can make random strings all day long, but it won't display a picture if its doesn't call the right image!

It's kind of fun to do the impossible! -Walter Elias Disney