2003

How to Bold text in MsgBox?

Also, in a MsgBox how to display numeric "text" formatted to show place a comma evey 3 numbers (i.e.
1,000 1,000,000) in a VBA computed number?

Thanks

EagleOne

EagleOne,

You cannot use bold in a msgbox - you need to use a custom form with a
textbox or label.

As for the format:

Sub NewSub()
Dim myVal As Double
myVal = 1234567.34
MsgBox Format(myVal, "#,##0.00")
End Sub

HTH,
Bernie

<donoteventry; <removes; wrote in message
...
2003

How to Bold text in MsgBox?

Also, in a MsgBox how to display numeric "text" formatted to show place a
comma evey 3 numbers (i.e.
1,000 1,000,000) in a VBA computed number?

Thanks

EagleOne