Add pictures to sheet with picture name based on cell content

[jprlimey]

I'm trying to add pictures to a sheet. The location for the pictures will be a pre-determined folder, the picture names will be in a merged cell lets say cell E10 (the merged cell cover range E10 thru E15 and gets populated from a text box on a user form), the merged cell may have up to 5 or 6 pictures names.

What i would want to do is first look to see if E10 contains picture names, if so then place the pictures on to the sheet in a location below information already on the sheet, lets say last information on sheet is on row 60 and the last column of data used is F. When the pictures are added i would want them distributed such that they will print on page 2 of the sheet.

Does anyone have any ides or is this something that not doable.

Thanks

[Leith Ross]

Hello jprlimey,

I would add the pictures from the UserForm. Since the names are entered into a TextBox, why copy them to the worksheet and make more work?

[jprlimey]

Leith,

Thanks for your suggestion.

Once the user form is closed all the selected information from the user form and picture names input into the text box is transferred to the sheet. The information on the sheet is then stored in a database for retrieval later.

Later, when we retrieve the information for distribution to the production area, we re-load the user form which then populates the sheet, at this time we would print off the 1st sheet and if pictures existed we would also print sheet 2. We did it this way to reduce the massive number of dedicated files that would become very cumbersome to edit, alter and not to mention the file size.

So the sheet that is populated from the user from is essentially a template, as such we really don't want to add the pictures to the template

Thanks

[Leith Ross]

Hello jprlimey,

Understood. How would the picture names appear in the merged cell? Would they be delimited by commas? Need to know to be able to retrieve the names properly.

[jprlimey]

Leith,

The user form textbox is set to multiple line allowing me to enter multiple picture names, in the sheet the picture names would be listed one under another, just like a list.

for example:
picture1
picture2
picture3

Thanks

[jprlimey]

Hello jprlimey,

Understood. How would the picture names appear in the merged cell? Would they be delimited by commas? Need to know to be able to retrieve the names properly.

Leith,

Would this task be easier if the names were not in merged cells?

Thanks