Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-10 Thread Vaibhav Joshi
check this http://vbnet.mvps.org/index.html?code/comctl/lvledger.htm On Mon, Mar 9, 2015 at 6:03 PM, Sal Sal sal72...@gmail.com wrote: for experiment i have tested : http://www.vbnet.ru/forum/show.aspx?id=211608 but without success... 2015-03-09 13:31 GMT+01:00 Sal Sal sal72...@gmail.com:

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-10 Thread Vaibhav Joshi
Also this link is also working... http://www.excelforum.com/excel-programming-vba-macros/335820-listview-and-colored-line.html also check attachment.. On Tue, Mar 10, 2015 at 5:13 PM, Vaibhav Joshi v...@vabs.in wrote: check this http://vbnet.mvps.org/index.html?code/comctl/lvledger.htm On

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-10 Thread Sal Sal
WOW! Tks But i dont want to colorize font, in this case only alternate row color and where i change the alternate color from rows? For example i need to alternate row with vbblue and vbmagenta, wath is the parameter? 2015-03-10 13:57 GMT+01:00 Vaibhav Joshi v...@vabs.in:

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-09 Thread Vaibhav Joshi
Hi can you share sample data with userform for more clarity?? On Mon, Mar 9, 2015 at 4:26 PM, Sal Sal sal72...@gmail.com wrote: Tks, i know to colorite the cell in sheet, but my prob is to colorize background of cell in listview! For example in row 3 col 6 of listview item. Il 09/mar/2015

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-09 Thread Sal Sal
for experiment i have tested : http://www.vbnet.ru/forum/show.aspx?id=211608 but without success... 2015-03-09 13:31 GMT+01:00 Sal Sal sal72...@gmail.com: I need to colorize with vbblue, the background of cell Item 3 of column DUE, not the color font of cell (i know the way to do it).

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-09 Thread Sal Sal
I need to colorize with vbblue, the background of cell Item 3 of column DUE, not the color font of cell (i know the way to do it). 2015-03-09 12:27 GMT+01:00 Vaibhav Joshi v...@vabs.in: Hi can you share sample data with userform for more clarity?? On Mon, Mar 9, 2015 at 4:26 PM, Sal Sal

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-09 Thread Sal Sal
Tks, i know to colorite the cell in sheet, but my prob is to colorize background of cell in listview! For example in row 3 col 6 of listview item. Il 09/mar/2015 11:23 Vaibhav Joshi v...@vabs.in ha scritto: Hi You can use Range.Interior.ColorIndex property.. e.g.

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-09 Thread Vaibhav Joshi
Hi You can use Range.Interior.ColorIndex property.. e.g. Range(A1).Interior.ColorIndex = 5 On Sun, Mar 8, 2015 at 11:21 AM, Sal Sal sal72...@gmail.com wrote: Bug* but Il 07/mar/2015 17:09 Sal Sal sal72...@gmail.com ha scritto: Simply, colorize a cell background in Row 2 Column 5.

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-07 Thread Vaibhav Joshi
Can you explain with example through excel workbook? On Fri, Mar 6, 2015 at 1:46 AM, Sal Sal sal72...@gmail.com wrote: I know the way to colorize a font in a vba for excel listview but to colorize the background of cell in a listview? For example the cell in row 3, column 4?? --

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-07 Thread Sal Sal
Simply, colorize a cell background in Row 2 Column 5. Naturally the cell is in un a userform listview. Note: Not the colorfont bug the background color. Il 07/mar/2015 10:21 Vaibhav Joshi v...@vabs.in ha scritto: Can you explain with example through excel workbook? On Fri, Mar 6, 2015 at 1:46

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-07 Thread Sal Sal
Bug* but Il 07/mar/2015 17:09 Sal Sal sal72...@gmail.com ha scritto: Simply, colorize a cell background in Row 2 Column 5. Naturally the cell is in un a userform listview. Note: Not the colorfont bug the background color. Il 07/mar/2015 10:21 Vaibhav Joshi v...@vabs.in ha scritto: Can

$$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-05 Thread Sal Sal
I know the way to colorize a font in a vba for excel listview but to colorize the background of cell in a listview? For example the cell in row 3, column 4?? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page