VBA to insert images in a cell with dynamic URL

[tnyssd]

Hi Community,

I have a workbook where Column A is for manual input of SKU#.
I'd like to display an image of that product in Column B, where the image url has a static path except for the file name, which is the SKU#.

As such: storewebsite.com/library/product_images/SKU#.jpg

I'm looking for a VBA code where it will dynamically set the SKU# entered in Column A into the image url and auto display the image file in Column B.

Example:

A1 : 111
B1 : <img src="storewebsite.com/library/product_images/111.jpg height="XXX" width="XXX" />


Thanks in advance,

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[tnyssd]

Thanks for the response. I've attached a sample workbook.

I'm trying to figure out a VBA code that will display a web image in Column B if a value is entered in Column C.
The image url is storewebsite.com/library/product_images/{value entered in Column C}.jpg

So I need 2 functions.

1. The function to grab the value in Column C and insert that value in the image url to complete the web image url.
2. The function to embed/display that image in Column B with a set height x width.