Choose folder then file when insert image

[redapa1]

Hello,
Could anyone help me if possible with a VBA Code that inserts a .jpeg file from a 2 folders. To be more specific something like this :
Main Folder path: D:\Paul\Proiect fluturi\Cercetare\LEPIDOPERA DATA BASE\Plante gazda
The second folder \Ballota nigra ( is latin name of a plant) is part of Plante gazda folder .
The main cell value= "Plante gazda" Folder
The second cell will contain the .jpeg file name that need to be inserted in the Database
As exemple in Cell A1= Corn = Folder name --> the code must chose the folder by the A1 reference
in Cell A2= Pic1, Pic2, Pic3..... ( I will select it from a Data Validation list) = .jpeg file name --> the code must chose the file based on Cell A2 reference an inser the picture

Because this is a Database this must be dynamic, if search for another species and select another file it must delete the previous one.


As a note I am using a similar code that inserts a picture based only a cell value that equals with the .jpeg file name and it looks like this

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[redapa1]

My mistake thanks for the correction and for the advice this is my first post hope you understand