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

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

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

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