Skip to Content
0
Former Member
Oct 23, 2011 at 08:20 AM

Monitoring Cell Change

21 Views

Does anybody have a clever or neat solution to the following requirement?

I have 4 combo boxes and a Refresh button. The user has to click refresh whenever any of the combo boxes are changed. What they want is for the refresh button to change colour & text whenever any of the combo boxes change, before refresh is clicked. Once refresh has been clicked the button resets itself.

To achieve this I need to somehow save or snapshot the current selected values of the combo boxes and then do a compare whenever any of them change. It is effectively recreating the On Cell Change functionality of the data connections, but using canvas components.

It sounds simple and doable on the face of it but is proving rather tricky. If anybody has achieved something similar and has a good approach to share I would appreciate the steer. Cheers, Lee.