Splash Screen with formula?

Hi

I want to make a splash screen (i think its called that) but want to have an automated summary where i use formulas to determine the text.

I have created this as a dashboard on other reports, but am unsure if its possible using vba userforms and message boxes.

Say i have 2013 profit 8.2% (in cell a1) and 2012 profit 7.5% (in cell b1) with a difference of 0.7% (in cell c1) i would use

Formula:

="Profit has"&" "&if(c1>o,"Increased","Decreased")&" "&"by"&" "&c1

What i want to be able to do is to use this kind of formula but in a message box or userform, which i can put a time element on it, so that the user HAS to read the summary/text before accessing the spreadsheet.

I know how to do the time element but can this formula or similar formulas be built in?

just to add i know how to put the text in, its the formulas im unsure of

Any help or advice will be greatfully appreciated

Thanks

Dan

sorry the formula i use is

Formula:

="Profit has"&" "&if(c1>o,"Increased","Decreased")&" "&"by"&" "&text(c1,0.0%)