NUMBER FORMAT IN A VBA DIALOGUE BOX

F

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!
 
F

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Control tab does not appear in format control dialogue box 1
How to create a modal Dialogue Box? 6
Using VBA with Combo Boxes 6
Multiple Criteria from Qry Dialogue Box 2
Can't fix error message in Powerpoint "Format Axis" dialogue box 1
How can I make a dialogue box pop up with a notice to user? 2
formatting a number in a text box 1
What is the box character in a text field and how do I replace it? 2

Top