帮林岚处理一个Excel图表对象时,使用如下代码时:
Dim xlChart As ChartObject
Set xlChart = ActiveSheet.ChartObjects(1)
MsgBox xlChart.Name
xlChart.Activate
xlChart.PlotArea.Select
...
Function FormattedMsgBox( _
Prompt As String, _
Optional Buttons As VbMsgBoxStyle = vbOKOnly, _
Optional Title As String = vbNullString, _
Optional HelpFile As Variant, _
Optional Context As ...