listbox listindex problem

[jacob]

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.

 

[Dick Kusleika]

jacob

Try the BeforeUpdate event instead of Change.

 

[jacob]

Thank you.

-----Original Message-----
jacob

Try the BeforeUpdate event instead of Change.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com




.