Hi.
I have the below code to display the picture in userform.
Private Sub Load_Chart()
Dim sh As Worksheet
Dim myChart As Chart
Set sh = ThisWorkbook.Sheets("Sheet1")
If Me.ComboBox1.Value <> "" Then
Set myChart = sh.Shapes(Me.ComboBox1.Value).Chart
myChart.Export VBA.Environ("TEMP") & Application.PathSeparator & "MYCHART.jpg"
Me.Image3.Picture = LoadPicture(VBA.Environ("TEMP") & Application.PathSeparator & "MYCHART.jpg")
End If
End Sub
how can I show several charts when I select All in combobox?
Thank you
Bookmarks