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

J

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
 
R

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.
 
Top