#1
|
|||
|
|||
Message Box
Is keep spaces is the only way to start a new row in the message box or there is another way?
Also, how can I make a part of the message content bold or change the font size & color? Can I insert a small table (3 columns & 3 rows) in the message box? Thank you. Code:
Call MsgBox("You Are Not Authorized and you need to -------", vbExclamation, "Warning") |
#2
|
||||
|
||||
To start a new line in the message box you can use carriage return/linefeed characters. I tend to use vbNewLine:
Code:
MsgBox "hello" & vbNewLine & "the" & vbNewLine & "world!" To make part of the message content bold or format the size and colour, you have two choices. (1) Use some very complicated API calls (2) Instead of using the built-in messagebox, create your own userform to display the message. Option (2) is very simple and is the one I recommend. It would also be easy to have a table on your userform. |
#3
|
|||
|
|||
Colin,
I do really appreciate your help. Can you please advise me on links where I can learn about userform? Thank you. |
#4
|
||||
|
||||
Hi,
Perhaps this you tube video will help as a starting point: http://www.youtube.com/watch?v=5PN7lWJSobQ To begin with, you will be particularly interested in Label controls which will let you write your message on the userform. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Message Header | ritjohns | Outlook | 1 | 11-16-2011 01:20 PM |
Proofing message | geralds34 | Word | 2 | 05-02-2011 06:07 PM |
Autoforward message | 400ex4ever | Outlook | 1 | 01-06-2011 07:50 PM |
Pop Up Message on Open | Emma Samm | Word | 0 | 12-20-2010 02:38 PM |
Error message | White House | Outlook | 1 | 12-07-2010 04:52 AM |