Paste this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 And Target.Columns.Count = 1 Then
Application.EnableEvents = False
Target.Offset(, 2).Value = 0
Application.EnableEvents = True
End If
End Sub

in the code module for the worksheet concerned. Can be reached by
right-clicking on the sheet's tab and choosing 'View Code'. Paste where the
cursor is.
The 2 in Target.Offset(, 2).Value = 0 is 2 columns tothe right of the Target
column, which is column 1, represented by the 1 in If Target.Column = 1

--
p45cal


"Ahh, Excel's Tough" wrote:

Hi,
I was wondering if it was possible to automatically populate one
column after one column was filled, say I wanted to put something in
Column A then have a 0 pop up in column C immediately. Is there a
macro/formula to handle this type of operation? Once again, appreciate
the help that has been coming towards my topics and would like to
thank people for any assistance given.