Embedding Photos into Excel

[DPChristman]

I have a form that I created in Excel, that requires the embedding of photos in the report.

Is there a way to do a copy and paste, and get the photos to automatically fit into a pre-sized box?

I can do this manually by pasting an dragging the corners till the picture fits, but I am working with people who are not that comfortable with Excel, so I am looking for a more simplistic process.

Also trying to cut back on people turning a 50KB spreadsheet into a 10MB monstrosity

 

[Dan_W]

So you're using a Userform? And what control are you putting rhe images in? An imageBox?

 

[DPChristman]

So you're using a Userform? And what control are you putting rhe images in? An imageBox?

not sure what you mean by image box (I don't see that option). That is why I am trying to find the best way to do this for an inexperienced user

 

[Dan_W]

When you say you you created a form, what do you mean? Is this something that you made on the worksheet? Or something else?

I ask because Excel has something called userforms (which some people refer to as 'forms'), which are custom windows you can make and put things like buttons and text ones etc on it. There is also an image box which is a predefined box onto which you can put pictures etc.

I suppose the better question might be - are you looking to use VBA code for your solution?

 

[DPChristman]

When you say you you created a form, what do you mean? Is this something that you made on the worksheet? Or something else?

I ask because Excel has something called userforms (which some people refer to as 'forms'), which are custom windows you can make and put things like buttons and text ones etc on it. There is also an image box which is a predefined box onto which you can put pictures etc.

I suppose the better question might be - are you looking to use VBA code for your solution?

Just a format I threw together, prefer not to use any VBA if not necessary

 

[Dan_W]

Then that sounds like processing these images on the worksheet, and not the userform. I'm afraid I can only think of potential solutions in VBA.