General Ledger
Active Member
- Joined
- Dec 31, 2007
- Messages
- 460
Sorry if I am neglegent, but I am a new member to the board and not well versed in VBA.
I want to control the formatting of text that will appear in a message box using Excel 2003 VBA. I want to control the alignment, font, size, etc. For example, I want an OK only message box that reads;
--------------------------------------
Credit...
This spreadsheet was created by:
Your Friendly Neigborhood Spiderman
--------------------------------------
(If you are going to create something worthwhile, you might as well take credit for it.)
Where "Credit..." is the message box title. The following two lines should be centered. The second line in bold and use a larger font size.
Please be detailed in your response as I am fairly new to this.
Thanks.
I want to control the formatting of text that will appear in a message box using Excel 2003 VBA. I want to control the alignment, font, size, etc. For example, I want an OK only message box that reads;
--------------------------------------
Credit...
This spreadsheet was created by:
Your Friendly Neigborhood Spiderman
--------------------------------------
(If you are going to create something worthwhile, you might as well take credit for it.)
Where "Credit..." is the message box title. The following two lines should be centered. The second line in bold and use a larger font size.
Please be detailed in your response as I am fairly new to this.
Thanks.