auto calc

[scottishmovies]

Hi All,

I have a sheet with a set of charts and tables on it which reference a data validation cell called "chartdate" and is populated from another list of dates for the user to select which month to display.

I have excel calculation set to manual.

What I want to do is when a user changes the cell with the chartdate to calculate the sheet rather than pressing F9 to do it.

Any/All help appreciated.

Regards,
Pat

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("chartdate")) Is Nothing Then Me.Calculate
End Sub

 

[scottishmovies]

Absolutely Brilliant!
Worked a treat.

Thanks so much for such a speedy reply!

All the best,
Pat