: Now on my form  there is a field  which takes sum  of amounts as
: "=200+786+900+3" etc. I want to place  another text  field which
: should or would show  me the sum before placing the entered  data
: on worksheet.

Use Evaluate(). Draw a new form with two text boxes on it
and add this sub to the code. Type your expression (=200+786+900+3)
into TextBox1 and click the Tab key.

Private Sub TextBox2_Enter()
TextBox2 = Evaluate(TextBox1.Value)
' or TextBox2 = Evaluate(TextBox1.Text)
End Sub