VBA Code to Locate all Controls that have Conditional Formatting

[EddieN1]

Does anyone have a VBA (or other) routine that will identify all controls on a form that have conditional formatting?

Thanks, Eddie

[pbaldy]

It would involve looping the controls and testing FormatConditions(0). I suspect it will error if there's no format, so you'd handle that with an error trap.