i have some issue about how to show group image to userform.
i wrote some code to solve this proble but, error happened. ("error" Set CurrentChart = ThisWorkbook.Sheets("Grafik").Shapes("Group 5").Copy)
please help me to solve my problem, i really appreciate all answer. tks
Sub ChangeChart(ChartName As String)
Dim CurrentChart As Shape
Dim NamaGrafik As String
NamaGrafik = ThisWorkbook.Path & "\temp1.gif"
Set CurrentChart = ThisWorkbook.Sheets("Grafik").Shapes("Group 5").Copy
CurrentChart.Export Filename:=NamaGrafik, Filtername:="GIF"
FGRAFIK.Image1.Picture = LoadPicture(NamaGrafik)
End Sub
i wrote some code to solve this proble but, error happened. ("error" Set CurrentChart = ThisWorkbook.Sheets("Grafik").Shapes("Group 5").Copy)
please help me to solve my problem, i really appreciate all answer. tks
Sub ChangeChart(ChartName As String)
Dim CurrentChart As Shape
Dim NamaGrafik As String
NamaGrafik = ThisWorkbook.Path & "\temp1.gif"
Set CurrentChart = ThisWorkbook.Sheets("Grafik").Shapes("Group 5").Copy
CurrentChart.Export Filename:=NamaGrafik, Filtername:="GIF"
FGRAFIK.Image1.Picture = LoadPicture(NamaGrafik)
End Sub