View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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