Unable to configure Icon Set for a range

Good day!

I am trying to set up conditional formatting on a range using icon sets.

This should be achievable using the following steps:

1. Obtain a reference to the FormatConditions property of the Range object
2. Invoke the AddIconSetCondition method on the property to obtain a reference to an IconSetCondition
3. Set the IconSet property of the IconSetCondition object to an IconSet of your choosing
4. Obtain a reference to the IconSetCriteria collection of the IconSetCondition object
5. For each member of the IconSetCriteria collection set the values of the following properties as desired: Operator, Type, Value (you may also set Icon)

I am able to set the value of the Operator property, but when setting the values of either the Type or Value properties I get a 1004 Run-time error.

It is somewhat frustrating because this should be possible according to the example on Microsoft Learn. I have even copied the example on Microsoft Learn into my module and attempted to run it - it also does not work with the same error.
Here is the link to the example:

Would anyone be able to offer a solution?

P.S. Sorry, I've been disallowed from posting the link - just google learn.microsoft.com VBA IconCriterion for the example.

Remove this fragment:

Please Login or Register  to view this content.

Artik

Hello Artik

Did you run this code and did it work?
For me a run-time error occurs when assigning a value to either Type or Value properties.
I am using Microsoft 365 on Windows 11.

Here is a copy of the code from Microsoft Learn, which can be pasted into a new xlsm file.

Please Login or Register  to view this content.