Msgbox help

J

JonoB

I am trying to return a value to a msgbox, but instead of just the
actual value, I want the number to be formatted as fixed (i.e. using
"," as thousand seperator and only 2 decimal places).

My code so far is (and NAP is a named range in my worksheet):

_________

Dim getNAP
Dim msgA

getNAP = Range("NAP")

msgA = MsgBox("The final valuation is " & getNAP)
__________


This works fine, except I want the msgbox to show "The final valuation
is 19,352,654.23" instead of "The final valuation is 19352654.231432"


Thanks for the help.
 
M

merjet

I am trying to return a value to a msgbox, but instead of just the
actual value, I want the number to be formatted as fixed (i.e. using
"," as thousand seperator and only 2 decimal places).

MsgBox("The final valuation is " & Format(getNAP, "##,##0.00"))

HTH,
Merjet
 

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

Top