Pearson Software Consulting provides a free product
that I've used in the past. They describe it as follows

The best way to display diagnostic messages to users and
developers. Overcomes the limitations of MsgBox, Debug.Print,
and Application.Statusbar.
Recommended for intermediate and advanced developers.


It can be downloaded from
http://www.cpearson.com/excel/Alert.htm