LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting with Icon sets CC Excel Discussion (Misc queries) 4 April 21st 10 03:34 PM
Using the Icon Set for Conditional Formatting Gino59 Excel Worksheet Functions 1 February 11th 10 02:12 AM
Formatting Conditional Formatting Icon Sets The Rook[_2_] Excel Discussion (Misc queries) 3 March 7th 09 08:48 PM
change icon color traffic lights in conditional formatting jdhoogie Excel Discussion (Misc queries) 1 August 8th 08 11:04 AM
Conditional Formatting with the icon set Tubthumper Excel Discussion (Misc queries) 1 November 5th 07 10:12 AM


All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"