Macro that runs when worksheet is automatically updated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook that has a worksheet (Sheet1) for user entry. This updates
another worksheet (Sheet2) automatically with information specific for that
part number as defined in Sheet1.

I have a macro that puts a picture in Sheet2 and it works beautifully except
I need it to run when the information from Sheet1 changes Sheet2
automatically. How can I make that macro run whenever I switch to Sheet2.

(Sheet1 has data entered....Sheet2 automatically has field changes...needs
macro to run whenever switching to Sheet2 to view the data).

Thanx
 
Lets assume that you macro (called lambi) is in a public module.

In the worksheet code area for Sheet2 insert:

Private Sub Worksheet_Activate()
Call lambi
End Sub
 
Worked like a charm. Thanks for the code.

Gary''s Student said:
Lets assume that you macro (called lambi) is in a public module.

In the worksheet code area for Sheet2 insert:

Private Sub Worksheet_Activate()
Call lambi
End Sub
Click to expand...
 
Back
Top