Update image in Useform

[Rhadida]

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?

 

[Mike Blackman]

Hi,

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

    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]

Hi,

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

    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?