Board index MS EXCEL

listbox listindex problem

listbox listindex problem

Post by jaco » Wed, 25 Aug 2004 18:35:41


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.
 
 
 
Top

listbox listindex problem

Post by Dick Kusle » Thu, 26 Aug 2004 06:58:30

jacob

Try the BeforeUpdate event instead of Change.

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

 
 
 
Top

listbox listindex problem

Post by jaco » Thu, 26 Aug 2004 16:46:01

Thank you.
message

fire
is
displayed
 
 
 
Top

1. Listbox and setting Listindex

2. Listindex of top item currently displayed in a listbox

3. ListIndex Property in ListBox / ComboBox

4. Listbox.listindex

5. ListIndex on ListBox with Error Code 7777

6. Set listindex for listbox or combobox.

7. nothing selected in listbox, but listindex <> -1

8. ListBox3.ListIndex = ListBox3.ListCount -- How to select the last item in a Listbox?

9. ListBox, ListIndex and ListCount. A BUG???

10. Run-time-error 1004 "ListIndex method of listbox class failed"

11. Search Listbox & Return Listindex

12. listbox/listindex goes bad (suddenly!)

13. Run-time-error 1004 "ListIndex method of listbox class failed"

14. Coercing ListBox.ListIndex?

15. Problem with ListIndex = 0 in an AfterUpdate Event

All times are UTC
Board index