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

  • Thread starter Thread starter John Geddes
  • Start date Start date
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
 
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.
 
Back
Top