Shading Lines in Listbox with Similarities

[bstice]

I have a listbox displays information on orders and how much left there is to bill on a given order number. Sometimes the orders have several lines because there is value open on individual product ids that roll up into the order.

Is there a way using VBA or some other function to check the previous line and if the order numer is the same, shade those two lines gray? So the math would be:

IF the order number from the previous line = order number from current line then SHADE both lines gray.

Is this possible? Thanks

Brennan

 

[boblarson]

Is this possible? Thanks

Not possible with the built-in listbox. Stephen Lebans has an "enhanced" listbox that might work for you:
http://www.lebans.com/listboxenhanced.htm