VBA code Font.Bold

You would need to use a userform rather than a msgbox if you want to format the display in that way.

Your userform would need to labels in order to have the appearance of mixed formatting.

Hi Andy,

Yes i do have the UserForm and i made a sheet with parameters Param" if you can see in the code below, what i need to do is show only the labels Bold:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)


So you want the message in the actual email body to have the bold formatting? If so you will need to create the html required to have that appear.

This should give you a starting point on generating the html
http://www.rondebruin.nl/win/s1/outlook/bmail2.htm

no problem, thanks for updating your post.

something like this, I've done the first item adding the < B > and < BR > tags

Please Login or Register  to view this content.

In case you need to change fontstyle and Size:
[CODE]
Msg = Msg & "<B><font face=Calibri><font size=2>" & Me.Label1.Caption & "</B> : " & Me.ComboBox1.Value & "<BR></font>"
[/CODE