Use following VBA script to convert numeric value to comma separated format.
Function Test(varx As Variant) As Variant
Test = Format(varx,"###,###,###0.00")
End Function
Call VBA function from graphics page by passing variable tag as value and function as Test VbCallReturn(VbCallRun(VbCallOpen("Test",123456789.45))) .
Variable tag can also be passed directly. Refer VBA Format function in help for more info.
Function Test(varx As Variant) As Variant
Test = Format(varx,"###,###,###0.00")
End Function
Call VBA function from graphics page by passing variable tag as value and function as Test VbCallReturn(VbCallRun(VbCallOpen("Test",123456789.45))) .
Variable tag can also be passed directly. Refer VBA Format function in help for more info.
Released for:Schneider Electric South Africa
