Comma in number in msgbox
 

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.

Comma in number in msgbox
 

MsgBox Application.Dollar(12345)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike H." wrote in message
...
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.

Comma in number in msgbox
 

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."

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Mike H." wrote:

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.