How to Bold text in MsgBox?

  • Thread starter donoteventry;removes;pam
  • Start date
D

donoteventry;removes;pam

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
 
B

Bernie Deitrick

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
 
Top