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.

listbox listindex problem
 

jacob

Try the BeforeUpdate event instead of Change.

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

"jacob" wrote in message
...
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.

listbox listindex problem
 

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

"jacob" wrote in
message
...
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.


.