"Looping" Script 1

[NumberCrunchingMonky]

In a nutshell, I have a list of projects to which I linked a graph that plots data dynamically, based on the active row of the list. I scroll up or down to a particular project title, press the button the macro is assigned to, and the graph is updated with the parameters that correspond to the project title in the active cell.

I'd like to nix the button so that the graph updates automatically when I move the active cell up and down the list. I don't know if this would be "event" driven (ie. prompted by the movement of the active cell), or better accomplished by looping the script.

Here's the code:

Sub UpdateChart()
If ActiveCell.Row > 2 And ActiveCell.Row < 20 Then _
ActiveSheet.Calculate
End Sub

I appreciate your help,

NCM

 

[steveouthwaite]

The sheets have an event that will suit you just fine...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
call UpdateChart
end sub

in the sheet's code window (not a module)
you might need to change your UpdateChart to a Public sub (I can't remember if the default is public or private)


SteveO

 

[NumberCrunchingMonky]

Thanks, Steve, for your great help. I'll give this a shot.
Regards.
NCM