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.
Last edited by Sazza; 11-30-2011 at 09:32 AM.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks