WHY IN EXCEL97 SUDDENLY GET 'EXCEPTION ERROR'

[CAPTGNVR]

DEAR ALL
When using multiselct from a listbox, I get suddenly 'exception error'
and comp gets locked and i have to use CAD - CTRL-ALT-DEL. Can anyone
tell me why this error props up or what are the possible caruses for
this exception error to prop up.

 

[Tom Ogilvy]

I use multiselect all the time and don't have that problem. I doubt your
description will be enough for anyone to tell. Possibly your code is
seriously flawed.

 

[CAPTGNVR]

I use multiselect all the time and don't have that problem. I doubt your
description will be enough for anyone to tell. Possibly your code is
seriously flawed.

Thank you Tom
I thought so bcos the exception error used to prop up and was wanting
to know why this was happening. Can u pls tell me - since u use
listbox quite often-- I select multiple choice in the list box and
when i finish the update and come back to the listbox the old selected
items are still highlighted. Pls give me some clue to do this. I am
waiting for your response with hawk eye.

 

[Tom Ogilvy]

Like I said, this isn't a known problem. It must be something unique to the
code you are using or your environment. I certainly have had my share of
general exception errors when using userforms, but it is usually because I
try to change the list in the change event or something like that. It is
usually pretty obvious what I have tried that caused the problem, because
the problem appears when I make that change. I rectify these problems by
finding another way to accomplish what I need to do. There is no single
well established cause or single well established solution. It all involves
what you are doing.

 

[CAPTGNVR]

Mr. Tom
Roger ustand what u said. But pls answer for the below and i will
wait for ur response now.
I select multiple choice in the list box and
when i finish the update and come back to the listbox the old selected
items are still highlighted. Pls give me some clue to do this. I am
waiting for your response .

 

[Tom Ogilvy]

This will unselect all items

with listbox1
for i = 1 to .listcount - 1
.selected(i) = False
next i
End With

 

[CAPTGNVR]

This will unselect all items

with listbox1
for i = 1 to .listcount - 1
.selected(i) = False
next i
End With

THANK YOU TOM. It works. Finally i got the answer and thread is
closed.