I am trying to use a Private Sub Worksheet_Change event macro to change the
value of cell €œg12€� when theres a change to cell €œa3€�, and when cell €œg6€� =
1. Cell €œa3€� is itself the cell link of a combo box (created from the
€œForms€� toolbar). I know that this kind of macro only works under some
circumstances, but is this one of them? My code is:

Private Sub worksheet_change(ByVal target As Range)
If Not Intersect(target, Me.Range("a3")) Is Nothing Then
If Range("g6").Value = "1" Then
Range("g12").Value = "8"
End If
End If
End Sub