Comma in number in msgbox

[Mike H.]

How would I format the the display of a msgbox to get this result:

You have $2,145.50 worth of inventory!

The value 2145.5 is in the activecell, for example or in a variable, Amt.

 

[Don Guillett]

MsgBox Application.Dollar(12345)

 

[sebastienm]

Hi,
Try something like:

dim strValue as string

strvalue=Format( val(activecell.value), "$#,###.00")
strValue= "The value " & strValue & " is in the activecell, for example or
in a variable, Amt."