Skip to Content
0
Former Member
Feb 16, 2009 at 10:33 AM

BPC VBA - After_Changecvw

42 Views

Hi All, First Post...

I've been looking at the help files for using Excel VBA to trap events. I've noticed that function AFTER_CHANGECVW can to set to true/false - this does not appear to have any effect when changing its value.

When using BEFORE_CHANGECVW you can set this to false with the result being no change to the CV. I was hoping that by setting an AFTER function to false, this would roll back a change for the CV.

Am I missing something, or is there another standard way of rolling back a change on the CV based on a criteria.

Any response gratefully received....