Message Box w/Formula

[mtravis38]

Hello all,

I'm trying to write an Auto Open macro that displays a message in a dialog box when the spreadsheet opens. This in itself is simple (for me), but I'd like the message to be the result of a formula, and that part I cannot do. Any thoughts?

Excel 2010

 

[MrKowz]

What is your formula?

 

[VoG]

Hi. What is the formula?

 

[mtravis38]

=IF(ISBLANK($B18),"",IF((SUM($J18:J18)+SUM($E18:$G18)*SUMIF('1.2_SummaryOfParts'!$B:$B,$B18,'1.2_SummaryOfParts'!$R:$R))>=$A18,ROUND($A18-SUM($J18:J18),2),ROUND(SUM($E18:$G18)*SUMIF('1.2_SummaryOfParts'!$B:$B,$B18,'1.2_SummaryOfParts'!$R:$R),2)))

 

[VoG]

Perhaps (untested)

MsgBox Evaluate("IF(ISBLANK($B18),"",IF((SUM($J18:J18)+SUM($E18:$G18)*SUMIF('1.2_SummaryOfParts'!$B:$B,$B18,'1.2_SummaryOfParts'!$R:$R))>=$A18,ROUND($A18-SUM($J18:J18),2),ROUND(SUM($E18:$G18)*SUMIF('1.2_SummaryOfParts'!$B:$B,$B18,'1.2_SummaryOfParts'!$R:$R),2)))")

 

[mtravis38]

That worked! Thank you.

 

[VoG]

... falls off chair

 

[MrKowz]

... falls off chair

Evaluate is a dangerously powerful piece of code.