View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen Plotnick Stephen Plotnick is offline
external usenet poster
 
Posts: 16
Default Conditional Formatting icon change type problem

I'm building an Excel 2007 spreadsheet via VB 2005 and I'm trying to do some
conditional formatting with icon sets

I'm able to create an icon with the Green or Red traffic light (this must be
the default). When I try to change to the 5 arrow the VSE does not flag my
code as an error but at run time I get the following message.

Public member iconsets and type worksheet not found.

Here is the code to change the iconset.

cfIconSet.IconSet = osheet.IconSets(XlIconSet.xl5Arrows)

THanks,
Steve