Typically when creating a form, when I add a control to the form and doubleclick I am automatically taken to the form module code and a default control event is created.
When I go back to make modifications to the form at a later date by adding controls, if I choose to doubleclick the control, the editor is not automatically creating the default control event. I'm assuming this means that the editor is not recognizing the control. Most of the time if I save the file and exit excel altogether when I reopen the file the editor will recognize the new control. Lately Excel is showing instability when I add controls to a form this way. By instability I mean that Excel is crashing completely when trying to open these files.
I could use some enlightenment as to what is happening. I'm assuming I need to change a programming practice.
Thank you for any help in explaining this
When I go back to make modifications to the form at a later date by adding controls, if I choose to doubleclick the control, the editor is not automatically creating the default control event. I'm assuming this means that the editor is not recognizing the control. Most of the time if I save the file and exit excel altogether when I reopen the file the editor will recognize the new control. Lately Excel is showing instability when I add controls to a form this way. By instability I mean that Excel is crashing completely when trying to open these files.
I could use some enlightenment as to what is happening. I'm assuming I need to change a programming practice.
Thank you for any help in explaining this