| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn off highlight on Listbox after click_event
Is it possible to turn off the highlight of listbox choice after the
listbox_click event has fired? What is happening is that when I click the item, the event is fired and then I cannot chose the item again without chosing another item first. Thanks EM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off highlight on Listbox after click_event
You probably have to use the click event code to reset the value to -1. I
have not tried it, but it seems the logical thing to do. "ExcelMonkey" wrote: Is it possible to turn off the highlight of listbox choice after the listbox_click event has fired? What is happening is that when I click the item, the event is fired and then I cannot chose the item again without chosing another item first. Thanks EM |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off highlight on Listbox after click_event
Which property is being set to -1?
Thanks EM "JLGWhiz" wrote: You probably have to use the click event code to reset the value to -1. I have not tried it, but it seems the logical thing to do. "ExcelMonkey" wrote: Is it possible to turn off the highlight of listbox choice after the listbox_click event has fired? What is happening is that when I click the item, the event is fired and then I cannot chose the item again without chosing another item first. Thanks EM |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off highlight on Listbox after click_event
See ListIndex in the VBA help.
"ExcelMonkey" wrote: Which property is being set to -1? Thanks EM "JLGWhiz" wrote: You probably have to use the click event code to reset the value to -1. I have not tried it, but it seems the logical thing to do. "ExcelMonkey" wrote: Is it possible to turn off the highlight of listbox choice after the listbox_click event has fired? What is happening is that when I click the item, the event is fired and then I cannot chose the item again without chosing another item first. Thanks EM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
| VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Code to automatically turn on and turn off Track Changes | Excel Programming | |||
Linear Mode
