VBA code for the action of reading data and filling cells

[patrickmaas]

Dear all,

I've been making a large Excel file with lots of data and formulas. Its supposed to be a system for a specific department. I've made a sort of loading screen/splash screen when starting up where it says please wait while the program is loading. then at the same time the workbook starts calculating. The thing is the order of calculation on my workbook:
1. Calculate;
2. Reading Data;
3. Filling Cells;
4. Ready

These staps are showed in the status bar at the bottem of excel.
Now i've put this in the VBA Editer on the Thisworkbook sheet:
loading.Show
Application.CalculateFull
Completecalculation.Show

Application.CalculateFull only does the calculating part, it stops after that and leaves Reading Data and Filling Cells open for execution, so userform (completecalculation) which opens at last is not complete. It opens then closes and after it closes that userform it starts doing step 2 and 3. Its hard to explain but hopefully you will understand. I would like to add after application.CalculateFull another code to launch 2.Reading Data and 3. Filling Cells. After those steps are complete I would like to show the last userform which basicly says that everything is done and you can start to work with the excel file.

is there a specific name or something for the last to steps?

Thanks in advance,

Yours sincerely,
Patrick