Moving from one to another and then back again - on return the form does not refresh

dcfincham

New Member
Joined
Feb 8, 2009
Messages
12
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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,224,521
Messages
6,179,280
Members
452,902
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top