show the colored value of column in listview

[abdelfattah]

hi, everyone

i have data in sheet1 from range (a:d) , userform contains listview and the column d containes values of colored green and red i would show the colored value of column in list view is there any code do that ?

 

[Domenic]

You can use the ForeColor property of the ListSubItem object to set the font color. For example, the following line will change the font color for the 3rd ListSubItem (3 = Column D) from the first ListItem (1 = Column A), where myCell is a variable that represents a cell...

userform1.ListView1.ListItems(1).ListSubItems(3).ForeColor = myCell.Font.Color

Hope this helps!

 

[abdelfattah]

thanks for your replying but where exactly put the code which event?

 

[Domenic]

Presumably, you're using the initialize or activate event with either RowSource or .ListItems.Add and .ListSubItems.Add to add the items to your listview control. So you'll need to adapt it to your code in whichever event you're using.

If you need help adapting the code, post the code you're using to add the items to your listview control.