User Form timer

[mike.hansford]

I am a real beginner to VBA so bear with me...

I have a workbook that changes data from a drop down menu, which then takes around 20 seconds to calculate.

I have created a userform with a loading SWF file which i'd like to display for this duration.

I can show the user form but when i try to hide userfrom it continues to run. here is my code

Sub loading()


UserForm1.Show


Application.OnTime Now + TimeValue("00:00:05"), Wait

Unload UserForm1

End Sub


I am using Excel 365 pro plus
Thanks

Mike

 

[dmt32]

Hi,
welcome to Forum.
If trying to create a splash screen then have a look here:http://spreadsheetpage.com/index.php/tip/creating_a_splash_screen_for_an_excel_workbook1/

You can adapt solution to meet specific project need.


Dave

 

[mike.hansford]

Hi Dave,

Thanks for the link, it did exactly what i needed, however it seems that you cannot open the userform until the calculations have completed! This somewhat makes my userform pointless as it starts the timer after the calculations have completed.
Is this something you are aware of or know how to get around?

Thanks

Mike