golf4
Active Member
- Joined
- Jul 8, 2002
- Messages
- 452
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
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