Easy MsgBox Question

[businessman]

So this is probably an easy question but, I want to have a message box that will pop up and tell the user how many days are left until the due date of an issue. I can get the number of days by using

 MsgBox DateDiff("d", Date, [CriticalDate]), vbCritical

but how do i get it to display that date and some text after it as well so it will say " 63 days left til completion" instead of just "63"?

 

[Matt Greatorex]

So this is probably an easy question but, I want to have a message box that will pop up and tell the user how many days are left until the due date of an issue. I can get the number of days by using

 MsgBox DateDiff("d", Date, [CriticalDate]), vbCritical

but how do i get it to display that date and some text after it as well so it will say " 63 days left til completion" instead of just "63"?

 MsgBox DateDiff("d", Date, [CriticalDate]), vbCritical) & " days left until completion"

 

[businessman]

Thanks, I knew it was something simple

 

[Matt Greatorex]

As my Dad always tells me: Everything's simple, if you know the answer

 

[businessman]

It says that there is a type mismatch, error 13 when I use that string

 

[businessman]

ok it works now the vbCritical needs to be moved to the end of the statement