PDA

View Full Version : Run code when cell changes



FrymanSMU
05-01-2009, 12:42 PM
Ok, sorry I'm really not that good at Excel. I've learned some great tricks on this site for Access but my Excel is severely lacking!

I have a spreadsheet that has a cell for a report date, I used validation > List to make the cell a drop down. When the user selects a new date all my data recalculates but my pivot chart does not refresh. Does anyone know a code to run PivotCache.Refresh after a cell's value is changes? I know if Access I could use AfterUpdate or Lost Focus but that is not working here.

Thanks in advance.

Bob Phillips
05-01-2009, 02:44 PM
Use the worksheet change event.