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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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