I would like to copy Picture in Cell not sheet?

[Venterpj1]

I'm pretty new to Macros and userforms
I would like to add a picture in a cell (That is loaded from a userform), if possibly re size it so all the pictures are more or less (In Kb) the same size and that they also look uniform (In the cells / Range)
Then also save an original copy of the picture in a folder so I can reference / call back the original picture in full quality, on a later stage.

This is what i have so far:

Please Login or Register  to view this content.

This code saves picture in the sheet, not in cell

Any assistance will be greatly appriciated

[xladept]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


*You'd best do this immediately lest the thread be ostracized

And, welcome to the Forum!

BTW- where does the pic go? Is there an address that we can get the sizes from?

[Venterpj1]

Thank you, wasn't aware.

The pictures are saved locally,
Currently they are saved in a folder, but i would like to:
copy picture to the userform (From Google or wherever )
Rename the Picture
and save
one a small picture format in the backup sheet as a quick reference
and a proper quality in a folder that will be recalled from a later userform (Not yet made)

Should be saved in below:

Please Login or Register  to view this content.

But this doesn't work

[Kenneth Hobson]

Welcome to the forum! When you post in other forums, be sure to post links in each. http://www.mrexcel.com/forum/excel-q...not-sheet.html

When saving the image in the Excel file, and exporting to a BMP file, quality will degrade.

After setting the pic object, set the pic object's TopLeftCell to anchor it.


Here are some links that might help.

'http://www.ozgrid.com/forum/showthread.php?t=157246&p=572181

'http://www.excelabo.net/excel/userformdiv.php

'Stephen Bullen, PastePicture(), http://www.oaltd.co.uk/Excel/Default.htm

'http://www.mrexcel.com/forum/showthread.php?t=562721

''http://www.ozgrid.com/forum/showthread.php?t=112996

Fit a picture to a cell. http://www.vbaexpress.com/forum/show...-in-Excel-2007

[Venterpj1]

Thank you for the reply,
But as mentioned I'm pretty new to Macro's and userforms, SO how do you do it?

"When saving the image in the Excel file, and exporting to a BMP file, quality will degrade.

After setting the pic object, set the pic object's TopLeftCell to anchor it. "

Thank you