help with userform

[JasonLeVan]

I have a userform, and i have a chart on sheet2. I have a macro that saves the chart as a image then in the userform i have a image link of that chart, works great. except that if i make a change to the chart data, then save the picture and run the userform it does not load the newest picture, is there a way to make the userform refresh itself to the newest version of the saved picture

 

[MickG]

Try this :-
Place a Image frame in you userform "Image1" then run this code in the Userform Initialize _Event.
This will save your chart as a "gif" image file, and insert it on you sheet, refreshed each time the Image is loaded.

Private Sub UserForm_Initialize()
Dim Currentchart As Chart
Dim fname As String
Set Currentchart = Sheets("Sheet1").ChartObjects(1).Chart
fname = ThisWorkbook.Path & "\temp.gif"
Currentchart.Export Filename:=fname, filtername:="Gif"
Image1.Picture = LoadPicture(fname)
End Sub

Mick