Custom msgbox
Can Do
Goto Guest book sign in page [Home]
Thanks for visiting my site lucky visitor:
This page was last updated on: March 22, 2009
Copyright © 2002. XcelFiles. All Rights Reserved Ivan F Moala
Tell a friend about this page
Google
Search WWW Search My Site!

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.
http://216.92.17.166/board2/viewtopic.php?t=49224&highlight=xl97