hi all
how can i use the format function such that the number of dicemal points depends on value read from table
any ideas
thnx
format field
Hot Topic
- Collections Class For Each Next
- copying links from specific cells in a worksheet to specific cells in another worksheet
- Custom file description keywords: read/write in VBA via API
- Custom Date Picker Control
- Accessing Active Directory trough Access 2002
- How To Transfer Data to ADO Data Source from Excel with ADO
- Is Partner program open for non-consulting/non-ISV companies?
- Runtime Error #13 Type mismatch
- history of vba
- Macro to sort an Excel column
Microsoft ISV
- Problem with Applying Filter in MS Project 2003
- VBA for Powerpoint
- A Important Question about a program
- Help with the application-defined or object defined error
- Distribute elements extracted from XML to ListColumns or Cells
- printing .doc, .xls, and .pdf files from a list of filenames using an excel vba macro
- how to read merged cells?
- Application Error
- VBA for Powerpoint
- PowerPoint, WORD, and Macros
format field
Navneet Gupta
Per the support engineer:
We can use Format function to do it.
The sample shows how to format a string of a format from a variable.
Dim s As String
Dim y As String
y = "#,##0.00"
s = Format(4313413.9234, y)
MsgBox s
Now the y is from a const, we can read it from a table too. On the other hand, we can also to joint a string from some value.
-brenda (ISV Buddy Team)