Hallo, all.
What is happening all of a sudden?
While tidying up the code of a complex Macro I have somehow caused one of the user forms to behave strangely.
At the end of a subroutine the form is called with a .show command. The form appears just like always, but on the next command, which is "End sub", the form simply vanishes.
None of the other forms do this.
Maybe the problem is linked to the fact that the macro switches from one sheet to another and back again (but so do the ones that behave "properly").
Have any of you had a similar problem? What is causing it?
Grateful for any hints,
KenG
What is happening all of a sudden?
While tidying up the code of a complex Macro I have somehow caused one of the user forms to behave strangely.
At the end of a subroutine the form is called with a .show command. The form appears just like always, but on the next command, which is "End sub", the form simply vanishes.
None of the other forms do this.
Maybe the problem is linked to the fact that the macro switches from one sheet to another and back again (but so do the ones that behave "properly").
Have any of you had a similar problem? What is causing it?
Grateful for any hints,
KenG