Recalc & conditional formatting

[swas]

Hello,

I have a form with conditional formatting on several controls, including
setting enabled and back colour properties.

My problem is, the formatting is v e r y slow sometimes to react to changes
(10 - 20 seconds sometimes). Because some vary the enabled state, controls
can't be edited.

Using .recalc solves this problem, but because the formatting is based on
cell values, and recalc causes a form update, all my beforeupdate and
afterupdate events are firing at the wrong times!

Can controls conditional formatting be forced to update without recalc?


Thanks in advance.


swas

 

[John W. Vinson]

Hello,

I have a form with conditional formatting on several controls, including
setting enabled and back colour properties.

My problem is, the formatting is v e r y slow sometimes to react to changes
(10 - 20 seconds sometimes). Because some vary the enabled state, controls
can't be edited.

Using .recalc solves this problem, but because the formatting is based on
cell values, and recalc causes a form update, all my beforeupdate and
afterupdate events are firing at the wrong times!

Can controls conditional formatting be forced to update without recalc?

I haven't run into this particular issue, but at a guess, I'd try Repaint
rather than Recalc.

 

[swas]

Thanks for the comment John.

I have tried repaint, but unfortunately doesn't fire up conditional
formatting.

I think I will just write a subroutine that hard sets the back colour /
enabled settings directly. I can call this at will.


Thanks again.


swas