在图表所在表格键入
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
Calculate
Dim pic As Chart, frame As String
Set pic = ThisWorkbook.Worksheets("sheet1").ChartObjects("Chart 1").Chart
frame = ThisWorkbook.Path &Application.PathSeparator &"temp.gif"
pic.Export Filename:=frame, filtername:="gif"
UserForm1.Image1.Picture = LoadPicture(frame)
Application.ScreenUpdating = True
End Sub
再在表格上做一个VBA控件让UserForm1显示就可以了
Sub 显示()
UserForm1.show
End Sub
图表二类似 自己改一下吧
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)