PDA

View Full Version : VBA to upload image over another image



vbadumb
07-22-2017, 02:48 PM
I have images in each cell in column B. There are 1000 rows.
With VBA I want to add a picture over every image in column B.
I have given the full picture location address in each cell of "Column C" up to 1000 rows for column B cells.

Kenneth Hobson
07-27-2017, 07:24 PM
Welcome to the forum!

When you overlay, I guess you want the inserted picture to be the same size? As such, both pictures would be there but the overly would be the only one directly visible.

When inserting the picture, would you want it linked or embedded?

A short example file might be nice to work with to help you best. Maybe just 3 image files and an example XLSM with 3 rows of images. Click the Go Advanced button in lower right of a reply. Then the paperclip icon or click the Manage Attachments hyperlink below the reply block to attach the zip file.

vbadumb
07-29-2017, 04:36 AM
Picture in C are small compared to pictures in B column. So they can not overlay due to same size.

I want to put the C rows images in B row columns respectively. Then lock.

I want to change the position of overlay by up, down, left, right giving position in VBA.

By overlay I understand that "I am writing text(small) over white text area (big)" to post a message.