View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jahanzaib Jahanzaib is offline
external usenet poster
 
Posts: 4
Default Controls on Chart Forget assigned Macros.

Thanks for Reply Mr. Peltier,

I have moved code to the regular module.
Problem did not fix.

JB


"Jon Peltier" wrote:

The combo box should be assigned to a procedure in a regular code module,
unless you have defined a class module to capture ComboBox events, in which
case you need to instantiate the combo box as an instance of the class when
the workbook opens.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jahanzaib" wrote in message
...
Hello,

I have a combo box on my chart.
I have writtten a (Sub) procedure in a class module.
ComboBox calls the Sub A.
Works Accurately, but when I reopen my file, code does not run by ComboBox
and I have to re-assign Sub A to the combo box.

How can I resolve this??

JB