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

Conditional Formatting icon change type problem
 

I figured out the problem.

In case someone else needs this I'm refencing the sheet and need to
reference the book.

Steve
"Stephen Plotnick" wrote in message
...
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