Hi, As far as I know, msgbox controls are too limited to exploit them to change their color according to your needs. However, you can use another userform smartly instead to solve your purpose.
You can still have a look at (http://gregmaxey.mvps.org/Custom_MsgBox.htm), but not sure if it serves your purpose though. Regards, Bhaskar On Sun, May 17, 2009 at 2:39 AM, Alokeshwar Tiwary < alokeshwar.tiw...@yahoo.com> wrote: > Sorry, I had forgot to attach a subject line. > > > _________________________________________________________________________________________________ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > > ----- Forwarded Message ---- > *From:* Alokeshwar Tiwary <alokeshwar.tiw...@yahoo.com> > *To:* excel-macros@googlegroups.com > *Sent:* Sunday, 17 May, 2009 2:38:40 AM > *Subject:* > > Hi All, > > > Is there a way to change color of a message box back ground and font? > > Please see attached. I want the OK message box to be in same color as the > userform. > > > > Thanks in anticipation > > Alokeshwar > > > > > _________________________________________________________________________________________________ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > ------------------------------ > Explore and discover exciting holidays and getaways with Yahoo! India > Travel Click > here!<http://in.rd.yahoo.com/tagline_Travel_1/*http://in.travel.yahoo.com/> > > ------------------------------ > Explore and discover exciting holidays and getaways with Yahoo! India > Travel Click > here!<http://in.rd.yahoo.com/tagline_Travel_1/*http://in.travel.yahoo.com/> > > > -- Bhaskar S. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
