splash screen during macro running

[mani_singh]

hi again everyone,

anyone know how to setup a splash screen with loading bar to run whilst a long macro is running - macro runtime aprox. 4 mins

thanks

 

[VoG]

This should help http://www.j-walk.com/ss/excel/tips/tip34.htm

As an alternative approach see http://www.j-walk.com/ss/excel/files/developer.htm and scroll down to 'Control the LED Display in the StatusBar'.

 

[JoeS01]

this is an excellent reference, and works well. Can anyone please advise how I also can insert a string variable in the Userform?