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,