Traffic Lights

[Rocky0201]

Hi,

Is there a way to insert a traffic light using VBA into something (Image, TextBox, Label, ect) on a userform?

I found; Selection.FormatConditions(1).IconSet = ActiveWorkbook.IconSets(xl3TrafficLights1) ; in the Help section of my Excel but I cannot figure out how to implement this into my user form.

Thanks

 

[shg]

Maybe the easier method would be to use an image control and go find pictures you like.

 

[Mark05]

Traffic light the main purpose to control the traffic and save the life..

 

[SpillerBD]

You are wishing to have a Conditional Format Icon Set be displayed in your form?