VBA:Inserting Multiple Pictures With Sequence Into Multiple Cell

[Jhon Mustofa]

hi expert..

this macro code below working properly to insert picture from a folder with one by one select picture
i want to modified so macro work with criteria should be:
1. can insert picture from a folder with multiple select picture and insert to multiple cell at once
2. pictures can inserted automatically consecutive/sequentially placing into target cell (target cell are random) with name of file picture are random --> (main option)
3. if point #2 impossible to do it , to insert automatically consecutive can use name of file picture or based on name pictures like e.g. photo1, photo2,photo3, photo4, or whatever name's file picture etc....> (secondary option)
here code

Please Login or Register  to view this content.

cross a posting https://www.excelfox.com/forum/showt...cutive-Placing
attachment file as sample

any help, greatly appreciated
john m