Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform problem (Listindex) | Excel Discussion (Misc queries) | |||
listindex | Excel Programming | |||
ListIndex | Excel Programming | |||
ListBox problem | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |