Help Please

Posted by Tim on August 09, 2000 8:00 PM

Here's my dilemma, I have a constant amount in a single cell (A4) and I enter data in Cell (A5). I want to multiply the contents of A5 and A4 and have the results displayed in the cell A5.(The one that I just entered data in.) How do I do this? Thanks.

Posted by Dan on August 09, 0100 9:27 PM

The easiest way would just be to have the answer in cell A6...less of a hassle but if
you want the answer in A6 try the following as suggested by Tim Francis-Wright just a couple of days ago.....try:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not (Intersect(Target, Range("A1")) Is Nothing) Then
Range("A5").Value = Range("A4").Value * Range("A5").Value
End If
End Sub

Dan