| 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) | |||
Hybrid Mode
