right click sheet tabview codeinsert thissave.
Now, when anything is entered in col 3 (below row1) it will be multiplied by
col 2 and entered in col 4
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 2 Or Target.Column < 3 Then Exit Sub
Target.Offset(, 1) = Target.Offset(, -1) * Target
End Sub

--
Don Guillett
SalesAid Software

"Seige Silver" <Seige wrote in message
...
I have a worksheet with three columns. Col1 is item, Col2 is price and
Col3
is quantity. I need a column 4 that calculates col2 * col3 and displays
total. I tried formulas, but i need the total to be displayed
automatically
whenever i navigate to that column after entering col 2 and col 3. I dont
want to drag the formula manually to se the results. It should be like
pure
forms. Any advice?