VBA help on MsgBox

[christopherw34]

I need to have a text box pop up once I run a report. I already have a MsgBox that comes at the end of the report like so MsgBox ("Report Generated. Click OK to see line totals."). Once "OK" is pressed, I need the next box to display some information that is generated by a Countif formula. Example below.

=COUNTIF(H:H,"Z3")+COUNTIF(H:H,"Z4)

Would some be so helpful?

Thanks!

[tigeravatar]

christopherw34,

This should accomplish what you're looking for:

Please Login or Register  to view this content.