text box to show time taken

Hi guys



I have some vba that ends with a text box being displayed that says "file created"



I would like to add to that text box how long it took.



My initial thoughts are to add to the start of the code a variable that stores the current time (stTime)



and at the line before the text box is shown get the time again (endTime)

and subtract one from the other to get the time taken in mins and sec



How would I achieve this

text box to show time taken