Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fancy lookup | Excel Worksheet Functions | |||
Need to do a fancy string copy plus | Excel Discussion (Misc queries) | |||
Fancy Object Declaration | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |