Input box format variable to $0.00 Format
 

I'm sure this is easy but I can't find how to do using the Help. Is there
any way to format a variable within an input box so that it shows up
formatted as dollars? Like: $12,345.57 I'd like the Remaingfunds to have
the dollar format like: $12,345.57. Code is below

Msg = "Do you want to enter another Line for this grant? " & vbCrLf &
vbCrLf & "You have $" & Remaingfunds & " left!"
Title = "Enter the another Line?"
Response = MsgBox(Msg, vbYesNo + vbQuestion, Title)


Thanks for the Help!!

Input box format variable to $0.00 Format
 

You are close!

Msg = "Do you want to enter another Line for this grant? " & vbCrLf &
vbCrLf & "You have " & format(Remaingfunds,"$#,###.00) & " left!"
Title = "Enter the another Line?"
Response = MsgBox(Msg, vbYesNo + vbQuestion, Title)

--
JNW


"Mathew" wrote:

I'm sure this is easy but I can't find how to do using the Help. Is there
any way to format a variable within an input box so that it shows up
formatted as dollars? Like: $12,345.57 I'd like the Remaingfunds to have
the dollar format like: $12,345.57. Code is below

Msg = "Do you want to enter another Line for this grant? " & vbCrLf &
vbCrLf & "You have $" & Remaingfunds & " left!"
Title = "Enter the another Line?"
Response = MsgBox(Msg, vbYesNo + vbQuestion, Title)


Thanks for the Help!!

Input box format variable to $0.00 Format
 

Thanks for the help! Your code worked very well after I took the $ out. See
below! Again Thanks!

Msg = "Do you want to enter another Line for this grant"
vbCrLf & vbCrLf & "You have " & format (Remaingfunds,"#,###.00) &
" left!"
Title = "Enter the another Line?"
Response = MsgBox(Msg, vbYesNo + vbQuestion, Title)


"JNW" wrote:

You are close!

Msg = "Do you want to enter another Line for this grant? " & vbCrLf &
vbCrLf & "You have " & format(Remaingfunds,"$#,###.00) & " left!"
Title = "Enter the another Line?"
Response = MsgBox(Msg, vbYesNo + vbQuestion, Title)

--
JNW


"Mathew" wrote:

I'm sure this is easy but I can't find how to do using the Help. Is there
any way to format a variable within an input box so that it shows up
formatted as dollars? Like: $12,345.57 I'd like the Remaingfunds to have
the dollar format like: $12,345.57. Code is below

Msg = "Do you want to enter another Line for this grant? " & vbCrLf &
vbCrLf & "You have $" & Remaingfunds & " left!"
Title = "Enter the another Line?"
Response = MsgBox(Msg, vbYesNo + vbQuestion, Title)


Thanks for the Help!!