This is what I need:

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

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

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

Any ideas

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