NUMBER FORMAT IN A VBA DIALOGUE BOX

[FARAZ QURESHI]

How to present a message box as:

PRICE: $100,000
RATE: 10.50%
QUANTITY: 1,000 Tons
DATE: 28-Aug-2007
VARIANCE: (3,105.56)

Kindly note that all five numbers are variables and may be of any value.

Furthermore, how to make a carriage return in a VBA Box?

Thanx in advance!

 

[FARAZ QURESHI]

An example so far structured is:

MsgBox "Price: " & PRICE & "!" & vbNewLine & "Rate: " & RATE & vbNewLine &
"Quantity: " & QTY & vbNewLine & "Date: " & DATE & vbNewLine & "Variance: " &
VAR"

I have separate sub procedures for PRICE, RATE, QTY, DATE & VAR.

Its only the format I am concerned with.

Regards,

FARAZ!

 

[Dave Peterson]

MsgBox "Price: " & format(PRICE, "$#,##0.00") & .....