Thread: worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default worksheet

Yes, use some code in the receiving worksheet's _Change() event handler to
deal with it. The Change event is triggered when a value in a cell on the
sheet changes either by user input or as the result of VB code altering a
cell's contents. I am interpreting your term "procedure" to mean the result
of some VB code action.

It does NOT fire if the change results because of a formula
calculation/recalculation in a cell.

You'd probably want to include a statement at the start of your event
handler as
Application.EnableEvents = False
and then do your processing dealing with the change(s)
and then just before exiting the event handler:
Application.EnableEvents = True

The reason for this is that each change in each cell can trigger the Change
event, and since I imagine you may be working with more than one cell at a
time, you don't want to call your event handler 50 times for a 50 cell change.

"Curt" wrote:

is there a way to have data that is copied from another worksheet by a
procedure trigger a procedure on the worksheet that receives the data. This
would be app to each row as data is entered in parent worksheet.
This community sure is a great bunch.
Thanks