Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code that calculates a total cost:
Private Sub CmdCost_Click() If Me.txtQuantity.Value < "" Then prod = Me.lboProduct.Value Pprice = Application.WorksheetFunction.Index(Range("Price") _ , Application.WorksheetFunction.Match(prod, Range("Product"), 0)) MsgBox Pprice * txtQuantity, vbOKOnly, "Total Cost" End If End Sub Currently the total cost appears in the message box, but is there anyway i can get the format of the cost to include a $ and if possible two decimal places. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MessageBox Assistant | Excel Programming | |||
messagebox help | Excel Programming | |||
Anything wrong with Messagebox API? | Excel Programming | |||
Printing messagebox | Excel Discussion (Misc queries) | |||
messagebox problem | Excel Programming |