Fancy tricks in Listbox?

[jasonsweeney]

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

 

[Rob van Gelder]

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

 

[jasonsweeney]

Rob,


The version I have now does that....but the boss wants everything t
fit onto one page so no scrolling is necessary.....I have dozens o
rows of information.,,,

thus I was hoping there was some way. No way to change the color o
the selction highlight in list boxs??

 

[Tom Ogilvy]

No.

 

[Rob van Gelder]

Not with listboxes embedded in a worksheet (at least, not that I know of).

You could try to embed another control, say, a listview control. Trouble is,
it would not be linked to cell content. You would have to catch worksheet
changes and update the listview by code.
Listview has checkboxes which allows elegant multiselect. I've also seen
rows coloured

Be aware, I never embed controls into worksheets, so I can't tell you for
sure whether it will work.