Most valuable professional
  • Hot Topics

Excel embedded chart events, module confusion

Hi all I am confusing myself over where code needs to sit, and standard versus class modules. I have an embedded bar chart, that needs to run a macro when any of the bars are selected. when this was a chart sheet it worked fine, but I can seem to get it working as an embedded chart. Currently my class module looks like this: Code: Public Private Sub mychartclass_Select(ByVal Application.Run "MFChart" MsgBox "Success" End Sub In the Thisworkbook code: Code: Private Sub Workbook_Open() Application.Run "InitialiseChart" End Sub and in a standard module: Code: Sub End what am i doing wrong, have i got something in the wrong place ? Many thanks for any help or guidance. Excel 2003 by the way.

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of February 10, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel