product calculation in excel

[Guest]

can anyone advice me on the below scenerio?
eg. a * b = c

In cell A1, I input value a. I need to get c in cell A5. But b can only be
input in cell A5 too. Meaning when I key in b in cell A5, automatic c will
appears in cell A5.

Is there a way to do in excel? Please advice. Thanks.

 

[JE McGimpsey]

You can't have both a manually entered constant and a formula in the
same cell. However you can do this with an event macro. Put this in your
worksheet code module (right-click the worksheet tab and choose View
Code):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If .Address(False, False) = "A5" Then
Application.EnableEvents = False
.Value = .Value * Range("A1").Value
Application.EnableEvents = True
End If
End With
End Sub