View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jacob Jacob is offline
external usenet poster
 
Posts: 26
Default listbox listindex problem

Hi,
Have a single selection option type listbox which fire
a _Change event. If certain conditions are met the
listindex property is set to -1. The problem I'm having
is that after the listindex property is set to -1 this is
overriden by VB to the listindex representing the new
item selected by the user, thus the listbox is displayed
with an item selected. What I want though is to have no
item selected. Any way around this?

Any help appreciated.