Fancy tricks in Listbox?
 

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

Fancy tricks in Listbox?
 

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/

Fancy tricks in Listbox?
 

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??

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

Fancy tricks in Listbox?
 

No.

--
Regards,
Tom Ogilvy

"jasonsweeney " wrote in
message ...
Rob,


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

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


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

Fancy tricks in Listbox?
 

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.

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


"jasonsweeney " wrote in
message ...
Rob,


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

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


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