Show Picture in UserForm contained within Embedded Worksheet.

**Environment** · 09-24-2012, 04:50 AM

Hi Everyone,

After looking around on the forum I discovered some work done by Stephen Bullen that allows an image within a userform to be generated from an image embedded within a worksheet. The attached example works perfectly and when I play around with the attached I can change the image, set up etc. to show what I need and it all works fine.

However when I try and recreate this from scratch I can only achieve a series of error messages (even if I copy and paste the code exactly the same). I think it has something to do with OLE Automation as referenced within the code, but I don’t know what this is?

Can anyone help me understand why the attached workbook code can’t be copy and paste into another book and still work?

Thanks for any help in advance.

E

**Winon** · 09-24-2012, 06:03 AM

Hello Environment,

See the attached WorkBook. I found no problem by adding more Pics!

Also see the "Please consider" note at the bottom of this Post.

**JosephP** · 09-24-2012, 06:06 AM

if you copy the whole baspastepicture module you should have no problems using pastepicture in another workbook

**Environment** · 09-24-2012, 06:42 AM

Hi Winon / JosephP,

Thank you both for your help. I've had another go and still no luck. So I'm starting to think it’s my settings / version of excel rather than a general VBA problem.

Thanks again
E

**JosephP** · 09-24-2012, 06:44 AM

unless you tell us what errors you are getting and where it's not really possible to help you ;-)

**Winon** · 09-24-2012, 12:50 PM

@ JosephP,

Hello JP,

I endorse your last post. We do need a more precise explanaition or example of the "problem" he has, which we don't seem to find.

**divyateja@24** · 07-26-2013, 04:26 AM

Hi

can any one help me out to insert pictures in a cell by code using a userform with list of pictures

**divyateja@24** · 07-26-2013, 04:30 AM

I have created a file were i need to insert a picture for different codes,

example code 1 for picture 1

in my data base sheet i select the code and picture should appear in the next cell were i give reference.

The same action i wan to do it in different cells for all the cases i need to get same list and selected should appear in different cell.

Like if i select in a1 the picture should appear in b1 if i select the code in a2 the picture appear in b2

**JosephP** · 07-26-2013, 04:34 AM

welcome to the forum :-)

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster responses, too.