Run-Time Error While Loading Chart On UserForm Image

[Rajeshkumar R]

Dear Friends,

I have Graph Named As “MM_CHART” on my worksheet i.e. “RC Category”

Same Graph I would like to load on my userfrom (image2) when it gets Initialized or Activated

Below is the VBA Code which I am trying to use it. But it doesn’t load the Chart into Userfrom Image2

Please suggest me an alternate code which suits my requirement!

Please Login or Register  to view this content.

Looking forward your valuable Suggestion!

Thanks & Regards,
Rajeshkumar R

[Andy Pope]

First does the image get created?

Then is the image control configured to show the image correctly? Try setting the image to stretch fill the control

[Rajeshkumar R]

Dear Andy Pope,

Tried amending properties as "Try setting the image to stretch fill the control" still chart not loaded on Userform

Regards,
Rajeshkumar R

[Andy Pope]

The post an example file, as that code looks okay

[Rajeshkumar R]

Dear Andy Popo,

I am getting Following Error on highlighted Code when I am trying to Execute

Run-time Error '-214702424809(80070057)':
This member can only be accessed for a Chart Object

Please Login or Register  to view this content.

Thanks!
Rajeshkumar R

[Kaper]

Hi Rajeshkumar,
Have you seen the yellow banner at the top?
The code at first glance looks fine (at least for me), so before trying to help you more, I shall re-create the file.
Why shall I?
If you have no time to spare on such task, I also have no time for it.

[Andy Pope]

That error suggests the shape is not a chart

As requested post example file

[nigelog]

Works perfectly - are you sure your chart on worksheet is named MM_CHART and is a chart

[Rajeshkumar R]

Dear Experts,

My Apology on the Confusion here; I should have loaded the sample workbook beginning itself.

Please refer the attached Workbook and suggest me where I am going wrong and how to correct it?

Thanks & Regards,
Rajeshkumar R

[nigelog]

If you run this you will see your picture/image is not listed as a chart on the worksheet

Please Login or Register  to view this content.

attached file loads the part of the image called "Chart 2"

[Rajeshkumar R]

Dear nigelog ,

Noted, Thanks a lot for your extended support. I could achieve what I was looking for!

Thanks & Regards,
Rajeshkumar R

[Andy Pope]

Do you really need to export the chart as an image in order to reload on the userform?

Why not have static images where the person is a separate image that position on the form depending on the value. You just need to calculate the width of an image as a percentage and then reposition the image of the person.