Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |