Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data input format | Excel Discussion (Misc queries) | |||
Checking format on input | Excel Programming | |||
Input data format from GIS | Excel Discussion (Misc queries) | |||
input box format | Excel Programming | |||
what is the format for an input cell? | Excel Discussion (Misc queries) |