Question on Formatting a "MsgBox" Box

[golf4]

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

 

[Zack Barresse]

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...mis/colo/soft/ktMsgBoxV313E.zip&name=ktMsgbox

 

[ErikWiggins]

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.

 

[golf4]

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

 

[Zack Barresse]

yup!

i have the original version anytime you want it. it's being, outsourced in a way :wink: , 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.

 

[golf4]

GREAT!!!

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


Thanks again,

Golf

 

[golf4]

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. ray: ray: ray:

Take care,

Golf