Probably is beyod the scope of listbox capabilities.
Why don't you use worksheet cells and hook into cell_onselectionchange



--
Rob van Gelder - http://www.vangelder.co.nz/excel


"jasonsweeney " wrote in
message ...
This is what I need:

In a listbox embeded in a worksheet (populated from cells in the
worksheet) , I need the user to be able to:

(1) simply left click on an item to highlight it, and then be able to
left click on another and also select it (exactly like holding down the
cntr key and selecting items, only I need it to happen by simply left
clicking on things...

(2) as people DO left click on various items, I need the highlight to
change color. Click on the item once, its green highlight....click a
second time its red highlight, third = blue, and fourth = yellow. I
also need to collect data on these clicks behind the scenes....if the
item is "blue", a "1" needs to entered in the cell next to the source
item.

Any ideas?


---
Message posted from http://www.ExcelForum.com/