Custom msgbox
Ivan F Moala
Can Do
Visits here
Goto Guest book sign in page [Home]
Greatest place to be
Thanks for visiting my site lucky visitor:
This page was last updated on: April 25, 2006
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


Download file here..............................