Update image in Useform

Rhadida

Board Regular
Joined
Nov 26, 2003
Messages
159
I have a userform that displays a picture of a chart. The chart-picture is a saved picture, on a static location and with a static name.

Once the chart changes, I let it save again, under the same name.

Now I want the userform to update it's picture, so the new picture shows?

I have already tried the .refreh, but that doesn't seem to work. Does anyone know how you can refresh the image?
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Mike Blackman

Well-known Member
Joined
Jun 8, 2007
Messages
2,494
Hi,

Here's an example of one what i've done in the past, you physically have to re-import the file.

Code:
    wsMap.ChartObjects("Whisker").Chart.Export Filename:=GenerateSystemFolderPath & "Whisker.gif", FilterName:="GIF"
    With frm_MainScreen.WhiskerChart
        '.Picture = LoadPicture("")
        .Picture = LoadPicture(GenerateSystemFolderPath & "Whisker.gif")
    End With
    Kill GenerateSystemFolderPath & "Whisker.gif"
 

Rhadida

Board Regular
Joined
Nov 26, 2003
Messages
159
Hi,

Here's an example of one what i've done in the past, you physically have to re-import the file.

Code:
    wsMap.ChartObjects("Whisker").Chart.Export Filename:=GenerateSystemFolderPath & "Whisker.gif", FilterName:="GIF"
    With frm_MainScreen.WhiskerChart
        '.Picture = LoadPicture("")
        .Picture = LoadPicture(GenerateSystemFolderPath & "Whisker.gif")
    End With
    Kill GenerateSystemFolderPath & "Whisker.gif"

Thanks for the reply, so there is no other way to refresh an image, you'll have to reinsert the image?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,139
Messages
5,599,951
Members
414,350
Latest member
ajesh27

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top