Please help me out in this frustrating problem. All this in one workbook with a Auto_Run(). In Auto_Run() i use UserForm1.Show to load and show UserForm1. In UserForm1_initialize(), UserForm1.Show is one of the statements.
In the UserForm1, there is a command button associated with a statement UserForm1.Hide.
The problem is that: When i click the HideUserForm button, an error message pops out "Subscript out of Range". And after i click "debug", the line "UserForm1.Show" in Auto_Run() is highlighted!!!! How come!!!! The click of HideUserForm button just activate one statement UserForm1.Hide......What happens here? UserForm1.Hide is not just to set Visible to False as stated in VBA help, is it???
Could you enlight what happens after UserForm1.Hide on earth? And how about UserForm.Show ?
In the UserForm1, there is a command button associated with a statement UserForm1.Hide.
The problem is that: When i click the HideUserForm button, an error message pops out "Subscript out of Range". And after i click "debug", the line "UserForm1.Show" in Auto_Run() is highlighted!!!! How come!!!! The click of HideUserForm button just activate one statement UserForm1.Hide......What happens here? UserForm1.Hide is not just to set Visible to False as stated in VBA help, is it???
Could you enlight what happens after UserForm1.Hide on earth? And how about UserForm.Show ?