Load picture into form not using 'LoadPicture'

**pfrattali** · 12-31-2010, 11:27 PM

How would I load a picture into an image control box in a form not using 'LoadPicture' from a file in a directory but taking an image/picture already embedded in another worksheet?
I'm talking about using a macro to do this, not the direct method of going into the Properties in the VBA editor.

Thanks.

**Leith Ross** · 12-31-2010, 11:40 PM

Hello pfrattali,

Copy the image using CTRL+C. Open the VB Editor (ALT+F11). Click on the image control. In the Properties window, Find Picture. Click the box the to the right and use CTRL+V to paste the image.

**pfrattali** · 12-31-2010, 11:51 PM

Originally Posted by Leith Ross

Hello pfrattali,

Copy the image using CTRL+C. Open the VB Editor (ALT+F11). Click on the image control. In the Properties window, Find Picture. Click the box the to the right and use CTRL+V to paste the image.

How do I do this using a macro? I want to be able to variably add different pictures when the Form is activated or shown.

**pfrattali** · 01-01-2011, 12:07 AM

How do load a picture that's in the clipboard into the image control box of a Form, using a macro?
Hope this helps to better understand what I'm looking for.

**Leith Ross** · 01-01-2011, 02:22 PM

Hello ,

This a lot of code for one macro that will paste what is on the clipboard into the Image object. Fortunately, it is very easy to use. Copy and paste the macro code into a separate VBA module in your workbook.

Example of Using the Macro

Please Login or Register  to view this content.

Macro Code to Paste Picture from Clipboard

Please Login or Register  to view this content.

**pike** · 01-14-2011, 02:07 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save