Add textbox 'legend' to a picture on a worksheet using VBA

bja2013

New Member
Joined
Jan 5, 2014
Messages
4
Hi.

I have created an Excel form that allows users to add up to 90-odd pieces of employee data including a picture of the employee and then send the information (as an attachment) to an email address via the commandbutton1.click event

At the other end, the receiver of the email saves the attachment and uses another workbook (containing all employee records) to open the email attachment and add the data to two of the worksheets: I put the text data into worksheet(1) and the image (if one is included) into worksheet(2) (for cosmetic reasons).

The text data is fine but the image data is causing me a lot of difficulty. I can get the image to save to worksheet(2) and add the name below etc but ideally I would like to add a textbox below each image to allow grouping of the two images for sorting purposes.

I have been researching and testing potential solutions for several hours now and I'm getting 'drained' so I am hoping someone out there has a solution that I am as yet unable to find. Any help would be greatly appreciated.

Cheers,
bja
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Watch MrExcel Video

Forum statistics

Threads
1,099,363
Messages
5,468,184
Members
406,569
Latest member
Quest_

This Week's Hot Topics

Top