Add Elapsed Time on UserForm Box

[Excel987]

Hi Everyone,
I have a UserForm box that display the percent completed of a certain. Is there away to add Time Elapsed on the same UserForm? I want to capture how long the macro runs. I have attached a working worksheet. Use the "Renewal Button" macro to see the UserForm box. Thanks!

Please Login or Register  to view this content.

[torachan]

we cannot manipulate a picture - Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Andy Pope]

Simple addition to code to output time elapsed in the caption of the userform

Please Login or Register  to view this content.

Otherwise add another label to the userform to display the information.

Also check your final msgbox calculation of time as it is not correct.

[Excel987]

Thank you Andy Pope very much, I appreciate your inputted solution, it worked great!