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>: > 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 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>: >>> >>>> 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 <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 11:23 "Vaibhav Joshi" <v...@vabs.in> ha scritto: >>>>>> >>>>>> 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. >>>>>>>>> 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 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?????????? >>>>>>>>> >> >>>>>>>>> >> -- >>>>>>>>> >> 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 of >>>>>>>>> this >>>>>>>>> forum @ https://www.facebook.com/discussexcel >>>>>>>>> >> >>>>>>>>> >> FORUM RULES >>>>>>>>> >> >>>>>>>>> >> 1) Use concise, accurate thread titles. Poor thread titles, >>>>>>>>> like Please Help, Urgent, Need Help, Formula Problem, Code Problem, >>>>>>>>> and >>>>>>>>> Need Advice will not get quick attention or may not be answered. >>>>>>>>> >> 2) Don't post a question in the thread of another member. >>>>>>>>> >> 3) Don't post questions regarding breaking or bypassing any >>>>>>>>> security measure. >>>>>>>>> >> 4) Acknowledge the responses you receive, good or bad. >>>>>>>>> >> 5) Jobs posting is not allowed. >>>>>>>>> >> 6) Sharing copyrighted material and their links is not allowed. >>>>>>>>> >> >>>>>>>>> >> NOTE : Don't ever post confidential data in a workbook. Forum >>>>>>>>> owners and members are not responsible for any loss. >>>>>>>>> >> --- >>>>>>>>> >> You received this message because you are subscribed to the >>>>>>>>> Google Groups "MS EXCEL AND VBA MACROS" group. >>>>>>>>> >> To unsubscribe from this group and stop receiving emails from >>>>>>>>> it, send an email to excel-macros+unsubscr...@googlegroups.com. >>>>>>>>> >> >>>>>>>>> >> To post to this group, send email to >>>>>>>>> excel-macros@googlegroups.com. >>>>>>>>> >> Visit this group at http://groups.google.com/group/excel-macros >>>>>>>>> . >>>>>>>>> >> For more options, visit https://groups.google.com/d/optout. >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > -- >>>>>>>>> > 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 of this >>>>>>>>> forum @ >>>>>>>>> https://www.facebook.com/discussexcel >>>>>>>>> > >>>>>>>>> > FORUM RULES >>>>>>>>> > >>>>>>>>> > 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and >>>>>>>>> Need >>>>>>>>> Advice will not get quick attention or may not be answered. >>>>>>>>> > 2) Don't post a question in the thread of another member. >>>>>>>>> > 3) Don't post questions regarding breaking or bypassing any >>>>>>>>> security measure. >>>>>>>>> > 4) Acknowledge the responses you receive, good or bad. >>>>>>>>> > 5) Jobs posting is not allowed. >>>>>>>>> > 6) Sharing copyrighted material and their links is not allowed. >>>>>>>>> > >>>>>>>>> > NOTE : Don't ever post confidential data in a workbook. Forum >>>>>>>>> owners and members are not responsible for any loss. >>>>>>>>> > --- >>>>>>>>> > You received this message because you are subscribed to a topic >>>>>>>>> in the Google Groups "MS EXCEL AND VBA MACROS" group. >>>>>>>>> > To unsubscribe from this topic, visit >>>>>>>>> https://groups.google.com/d/topic/excel-macros/LN4NdEr9s9s/unsubscribe >>>>>>>>> . >>>>>>>>> > To unsubscribe from this group and all its topics, send an email >>>>>>>>> to excel-macros+unsubscr...@googlegroups.com. >>>>>>>>> > To post to this group, send email to >>>>>>>>> excel-macros@googlegroups.com. >>>>>>>>> > Visit this group at http://groups.google.com/group/excel-macros. >>>>>>>>> > For more options, visit https://groups.google.com/d/optout. >>>>>>>>> >>>>>>>> -- >>>>>>>> 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 of this >>>>>>>> forum @ >>>>>>>> https://www.facebook.com/discussexcel >>>>>>>> >>>>>>>> FORUM RULES >>>>>>>> >>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>>> Advice will not get quick attention or may not be answered. >>>>>>>> 2) Don't post a question in the thread of another member. >>>>>>>> 3) Don't post questions regarding breaking or bypassing any >>>>>>>> security measure. >>>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>>> 5) Jobs posting is not allowed. >>>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>>> >>>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum >>>>>>>> owners and members are not responsible for any loss. >>>>>>>> --- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>> send an email to excel-macros+unsubscr...@googlegroups.com. >>>>>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> 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 of this forum @ >>>>>>> https://www.facebook.com/discussexcel >>>>>>> >>>>>>> FORUM RULES >>>>>>> >>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>> Advice will not get quick attention or may not be answered. >>>>>>> 2) Don't post a question in the thread of another member. >>>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>>> measure. >>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>> 5) Jobs posting is not allowed. >>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>> >>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>>>> and members are not responsible for any loss. >>>>>>> --- >>>>>>> You received this message because you are subscribed to a topic in >>>>>>> the Google Groups "MS EXCEL AND VBA MACROS" group. >>>>>>> To unsubscribe from this topic, visit >>>>>>> https://groups.google.com/d/topic/excel-macros/LN4NdEr9s9s/unsubscribe >>>>>>> . >>>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>>> excel-macros+unsubscr...@googlegroups.com. >>>>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> -- >>>>>> 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 of this forum @ >>>>>> https://www.facebook.com/discussexcel >>>>>> >>>>>> FORUM RULES >>>>>> >>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>> Advice will not get quick attention or may not be answered. >>>>>> 2) Don't post a question in the thread of another member. >>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>> measure. >>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>> 5) Jobs posting is not allowed. >>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>> >>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>>> and members are not responsible for any loss. >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to excel-macros+unsubscr...@googlegroups.com. >>>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> -- >>>>> 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 of this forum @ >>>>> https://www.facebook.com/discussexcel >>>>> >>>>> FORUM RULES >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> 2) Don't post a question in the thread of another member. >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> 5) Jobs posting is not allowed. >>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>> >>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>> and members are not responsible for any loss. >>>>> --- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "MS EXCEL AND VBA MACROS" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/excel-macros/LN4NdEr9s9s/unsubscribe >>>>> . >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> excel-macros+unsubscr...@googlegroups.com. >>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> >>> -- >>> 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 of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > -- > 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 of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/LN4NdEr9s9s/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
