BACKGOUND CHANGE LISTITEM IN LISTVIEW

[2009luca]

Im working with vba for ecxel.
in a userform have a listview1.
possible to colorize the background cell in row 2 colomun 4 in blue?

i know the way to change color in a cell font, but not to change the background color of a cell.
Tks.

 

[SkipVought]

Hi,

Have you checked the ListView object properties?

 

[SkipVought]

Here's a relevant reference...

https://msdn.microsoft.com/en-us/library/aa443482(v=vs.60).aspx

 

[2009luca]

Have you checked the ListView object properties? YES

 

[SkipVought]

...and there's no property for what you want?

 

[SkipVought]

BTW what version of Excel?

 

[2009luca]

excel 2007

 

[SkipVought]

So where are you at now?

 

[MajP]

No. You can change the forecolor in only.

 

[2009luca]

found this...

Link

but i cannot arrange for a listview in vba userform!!!!

 

[MajP]

Sure, if you are an expert in windows API have at it. Not the easiest thing to work with, IMO. Those who are good at it, can do some pretty cool things.

 

[strongm]

The technique outlined in that link is called OwnerDraw (and knowing that you may be able to Google for better, more comprehensive examples). It is a pretty powerful way of modifying how many of the built-in controls are displayed - but, as MajP hinst, it is not for the fainthearted.