Prev: Pasting Variable cell info into a macro
Next: USE THE "IF" STATEMENT IN EXCEL
From: Val on 18 May 2010 12:36
How do you update/append/delete records in various files automatically based
on the entry into the Summary file.
From: Chip Pearson on 18 May 2010 13:28
Your question is rather vague, but the core of the answer is to use
the Change event to execute the appropriate code when a value on the
Summary sheet is changed. Right-click on the sheet tab of your Summary
sheet and choose View Code. In the code module that opens up, enter

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then
Exit Sub
End If
If Not Application.Intersect(Range("A1:A10"), Target) Is Nothing Then
' your code here
End If

End Sub

This code will be automatically exectued when a value on the worksheet
is changed. The code test whether the cell that was changed (Target)
is within the range A1:A10 and if so then executes whatever you put in
the line ' your code here.

The Change event is triggered when a cell's value changes as the
result of the user typing in a cell or as the result of other VBA code
modifying the value, but not if the change is simply the result of a
calculation.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com





On Tue, 18 May 2010 09:36:14 -0700, Val
<Val(a)discussions.microsoft.com> wrote:

>How do you update/append/delete records in various files automatically based
>on the entry into the Summary file.
From: JLGWhiz on 18 May 2010 13:38
See if Ron's page helps:

http://www.rondebruin.nl/summary2.htm


"Val" <Val(a)discussions.microsoft.com> wrote in message
news:C30AD419-0AD4-410C-B858-6BCDA790F9C5(a)microsoft.com...
> How do you update/append/delete records in various files automatically
> based
> on the entry into the Summary file.


 | 
Pages: 1
Prev: Pasting Variable cell info into a macro
Next: USE THE "IF" STATEMENT IN EXCEL