Comma in number in msgbox

's Computer Specifications

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.

's Computer Specifications

MsgBox Application.Dollar(12345)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Mike H." <(E-Mail Removed)> wrote in message
news:400B11C4-E08C-4ABD-9FF7-(E-Mail Removed)...
> 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.

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert number with comma to number with dot	Wessel Troost	Microsoft Excel Discussion	2	18th Jul 2007 05:08 PM
HOW DO I PUT 'COMMA' IN NUMBER, AS I WISH	=?Utf-8?B?TWVlbmE=?=	Microsoft Excel Setup	1	23rd Feb 2007 04:33 PM
using VBA in Excel it changes the dot of a number to a comma	=?Utf-8?B?YWJ5Z29yYg==?=	Microsoft Excel Programming	4	13th Sep 2006 06:06 AM
A MsgBox or Form to display info without waiting for a close comma	=?Utf-8?B?S21oQ29tcHV0ZXI=?=	Microsoft Access Form Coding	2	25th May 2006 08:28 PM
Comma in Number Format	Erin	Microsoft Excel Misc	2	27th Aug 2004 05:38 PM