Conditional Formatting - can I read the logic condition in VBA?

[John Geddes]

I want to handle Conditional Formatting in VBA.

I can see how to READ and WRITE backColor, foreColor and fontBold using
".FormatConditions"

I can see how to WRITE the logic condition (using ".Add"),

But I can't see how to READ the logic condition.

Any suggestions?


John Geddes
England

 

[Rob Oldfield]

dim fc as formatcondition
for each fc in me.controlname.formatconditions
'read whatever from fc
next

Check the help for the FormatCondition object. Typing fc. will trigger the
intellisense to give you a list of properties.