Excel 2007 : Vba auto run question

[Sazza]

Hi Guys,

I have the below VBA on a worksheet called 'Totals'

Cell A1 on 'Totals' contains a value from the 'INFO' tab so "=INFO!B3"

When i change the value ( drop down) on the 'INFO' tab ( and replicated on the 'Totals' tab)
the macro does not fire. Only work for the first change mad ein drop down and not subsequently.

How do i make this fire each time i chane the value using drop down ?

Please Login or Register  to view this content.

[DBY]

Hello
Have you tried running your code from the Worksheet Change Event rather than the Selection Change? As you're not changing your cell selection it will not fire when you change the drop down value. The Change Event should recognize the value change, if your drop down is the Active Cell or Target value.