Msg Box including a variable.

[alexaronson]

Hello,

I want to make a message box that says the following:

"The system took 25 seconds to process."

Where the 25 is a variable.

I have the following code already.
Sub Time()
Dim t as Double, x
t = Timer
For x = 1 to 10
Blah Blah Blah
next x
MsgBox Timer - t
End Sub

As the code stands, I only get the 25 in the message box. How can I add the text?

Thanks,

 

[lenze]

MsgBox "The system took " & Timer-t & "seconds to process."

Are you sure "timer-t" is correct?

lenze

 

[alexaronson]

Lenze,

It worked like a charm!

Thanks for the Help!

 

[alexaronson]

Any idea on how I can truncate the timer output to 4 decimal places?

I am getting results of 0.45093593 seconds.

thanks again for the help!

-Alex

 

[VoG]

Try

MsgBox "The system took " & Format(Timer - t, "0.0000") & "seconds to process."

 

[alexaronson]

Thanks for the help in my enhancement. It works like a charm.