Results 1 to 7 of 7

Question on Formatting a "MsgBox" Box

This is a discussion on Question on Formatting a "MsgBox" Box within the Excel Questions forums, part of the Question Forums category; Hi, everyone - I hope everyone's day is going ok......... I was hoping I could get some guidance on one ...

  1. #1
    Board Regular golf4's Avatar
    Join Date
    Jul 2002
    Location
    Salem, OR
    Posts
    452

    Default Question on Formatting a "MsgBox" Box

    Hi, everyone -

    I hope everyone's day is going ok.........

    I was hoping I could get some guidance on one issue I'm having in developing some VB code for a msgbox. Basically, part of the msgbox coding reads:
    PaperWarning = MsgBox("PRIOR TO PRINTING ANY WORKSHEETS: Have you verified whether any household member qualifies for the Earned Income Disregard (MEID)??? Click YES once you've verified each household member's status and continue printing your worksheets. Otherwise, click NO and correct data entry.", vbYesNo, "REMINDER: CHECK MEID QUALIFICATIONS WITHIN HOUSEHOLD!!!")
    If PaperWarning = 6 Then
    ..... blah,,,,,blah,,,,,blah....

    The question that I have is about how I can format the actual msgbox box that appears when the code strip is activated. The changes I'm looking for is to [1] enlarge the box itself, [2] increase the font size of the text, and [3] possible change the color. Would I have to do this, somehow, within the code itself? I'm not finding a "Property" way of changing a msgbox box's format.

    Thanks for the help,

    Golf

  2. #2
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,470

    Default Re: msgBox

    have you tried ktMsgBox at Colo's web site? it's supposed to be able to do just what your asking, although i've never tried it to date.

    HTH

    edit: here is the download link if you'd like:
    http://cgi.members.interq.or.jp/sun/...&name=ktMsgbox
    Regards,
    Zack Barresse
    My book on Excel Tables
    ExcelTables.com
    All Excel Functions
    (If you would like comments in any code, please say so.)

  3. #3
    New Member
    Join Date
    Feb 2004
    Posts
    6

    Default Re: Question on Formatting a "MsgBox" Box

    The problem you are facing is that the code you are using for your message box is actually an API call to a Win32 function. With out going ot far over your head that means that it is a set bit of code inside windows used by all applications. In order to change the color you sould have to have a c++ compiler and that is just way more then you are asking for. What you could do is create your own message box with the vb editer and then call that form to load. With a VBA form you can set the colors, fonts ect any way that you like. The only draw back is that it would mean that your spreadsheet would have a built in mirco and this size (in memory) will be large becuase you have a form inside it.

  4. #4
    Board Regular golf4's Avatar
    Join Date
    Jul 2002
    Location
    Salem, OR
    Posts
    452

    Default Re: Question on Formatting a "MsgBox" Box

    Hi, Zack & Erik -

    Thanks for the quick responses --- really appreciate the ideas.

    Zack - Sorry for not getting back to you on the Jeopardy PPT program. My computer, at home, did the big CRASH :x based on some of these wonderful viruses floating around out there. Had to take it in to have everything cleaned up, had everthing upgraded and just got back on-line last night. Is it still ok for me to send you my address stuf for a copy?

    Thanks again,

    Golf

  5. #5
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,470

    Default Re: Question on Formatting a "MsgBox" Box

    yup!

    i have the original version anytime you want it. it's being, outsourced in a way , to obtain double jeopardy also. i can send you an original copy now, and an updated one when i receive that too. just don't forget to specify how many copies you would like.

    btw, cd's are cd-r, not cd-rw, and will be burned w/ nero v 6.
    Regards,
    Zack Barresse
    My book on Excel Tables
    ExcelTables.com
    All Excel Functions
    (If you would like comments in any code, please say so.)

  6. #6
    Board Regular golf4's Avatar
    Join Date
    Jul 2002
    Location
    Salem, OR
    Posts
    452

    Default Re: Question on Formatting a "MsgBox" Box

    GREAT!!!

    I'll send you a PM when I get home from work tonight.


    Thanks again,

    Golf

  7. #7
    Board Regular golf4's Avatar
    Join Date
    Jul 2002
    Location
    Salem, OR
    Posts
    452

    Default Re: Question on Formatting a "MsgBox" Box

    Hi, Zack -

    I just downloaded and installed Colo's ktMsgBox utility and gave it a shot.

    MAN O' MAN!!!!! IT WORKS FANTASTIC. The included wizard works like a charm. Thanks so much for the heads-up. Highly recommended for everyone.

    Take care,

    Golf

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com