title: How to i set my GIF visible when i run userform? (VBA)
body: <p>My chart only updates and shows itself on my running userform, when i click the temp.gif file on my desktop. How do i get it to automatically show itself when i run the code?</p>
  
  <p>This is my code:</p>
  
  <pre><code>Private Sub Image1_Click()
  
  Dim ws As Worksheet
  
  Set ws = ThisWorkbook.Sheets("Sheet")
  
  'ws.ChartObjects("Chart 2").Chart.Activate
  
   Set CurrentChart = ws.ChartObjects("Chart 2").Chart
  
  
      Fname = ThisWorkbook.Path &amp; "\temp.gif"
      CurrentChart.Export Filename:=Fname, FilterName:="GIF"
  
      Image1.Picture = LoadPicture(Fname)
  
   End Sub
  </code></pre>
  
  <p>Sincerly,</p>
  
  <p>Peyko.</p>