Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
Sub Item_CustomPropertyChange(strName)
Select Case strName
Case "FieldA","FieldB","FieldC"
Item.UserProperties.Item("Composite") = _
"Value for A = (" & Field_A_Formula() & ")" & vbLf _
& "Value for B = (" & Field_B_Formula() & ")" & vbLf _
& "Value for C = (" & Field_C_Formula() & ")"
End Select
End Sub
Function Field_A_Formula()
'Edit the calculation on the next line'
Field_A_Formula = Item.UserProperties.Item("FieldA").Value
End Function
Function Field_B_Formula()
'Edit the calculation on the next line'
Field_B_Formula = Item.UserProperties.Item("FieldB").Value
End Function
Function Field_C_Formula()
'Edit the calculation on the next line'
Field_C_Formula = Item.UserProperties.Item("FieldC").Value
End Function
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
So, you want it to read exactly like this
Value for A = (the calculated amount for A)
Value for B = (the calculated amount for B)
Value for C = (the calculated amount for C)
Is that correct?