On 02/12/2011 06:18 PM, Shay wrote:
> For instance, I want to enter a value into B1 and have the value from A1
> added to it. Any help?
>
You could try to start with something like this VB macro code for 
ThisWorkbook object:

Private Sub Workbook_SheetChange(ByVal Sh As Object, _
         ByVal Source As Range)
    If (Source.Address = "$B$1" _
    And Sh.Name = "Sheet1") Then
      Application.EnableEvents = False
      Source.Value = Source.Value + Cells(1, 1).Value
      Application.EnableEvents = True
    End If
End Sub

Is there a real need for this, why not to use for example
simple formula in extra cell "=B1+A1"?

Post a reply to this message