How to do a macro in Excel with random pics?

Closed
umbur - Sep 20, 2017 at 06:05 AM
 Blocked Profile - Sep 20, 2017 at 04:32 PM
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

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
0