Controls on Chart Forget assigned Macros.

  • Thread starter Thread starter Jahanzaib
  • Start date Start date
J

Jahanzaib

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
 
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
 
Thanks for Reply Mr. Peltier,

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

JB
 
After assigning the macro to the combobox, has the file been saved?

- Jon
 
Hi,
Yes!
Does it has any connection with Protect-Unprotect Sheet?
JB
 
I don't think so, but if the control (or rather its shape container) is
locked, then maybe you cannot press it to activate the macro. When you right
click to assign a macro, is any macro already selected for the control? It's
a Forms menu control, right?

- Jon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple combo boxes and event handler class 1
ComboBox Dropdown not under control 1
preventing comboboxes from triggering when sheet copied 1
Access Control on subform / combo box requesting parameter 0
Raise Event Problem 4
location of combobox and chart 9
Macro to control two workbook 1
Class Raise Event not firing 3

Back
Top