The following is an API method to change the std Msgbox of Excel to one of your own choosing. Whilst it maybe easier to perofrm this via the use of a Userform, this method does give you an example of subclassing. In order to use subclassing you need the Addressof Function available in Excel version greater then 97 ie 2000+
There is a work around for his, if any one is interested then mail me and I'll put one up here.
Please note: This code is not mine, I amended it from code found here.
Taken from Original Question @ MrExcel board that I helped with.