Hi
I am having a problem ( after having gotten past the undocumented size limit on a form) when I have a spreadsheet which uses 2 forms. When I open the sheet the first form opens and display one of the sub pages. I then move to the second form (currently done on activating a subpage on the first form) and that works fine. When I then close the second form I can return to the first form again but it does not display the data on the subpage which I return to.
I have tried using a repaint, running the Form_Initialize again and using a DoEvents function (not sure what that does but found that suggestion on the internet). None of these seem to work. The only way I can get the data to reappear is to move to another subpage and then return to one which did not display the data.
Any clues on how I can get the data to show on the subpage when I return form the second form?
Thanks
Dave
I am having a problem ( after having gotten past the undocumented size limit on a form) when I have a spreadsheet which uses 2 forms. When I open the sheet the first form opens and display one of the sub pages. I then move to the second form (currently done on activating a subpage on the first form) and that works fine. When I then close the second form I can return to the first form again but it does not display the data on the subpage which I return to.
I have tried using a repaint, running the Form_Initialize again and using a DoEvents function (not sure what that does but found that suggestion on the internet). None of these seem to work. The only way I can get the data to reappear is to move to another subpage and then return to one which did not display the data.
Any clues on how I can get the data to show on the subpage when I return form the second form?
Thanks
Dave
