View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
CAPTGNVR CAPTGNVR is offline
external usenet poster
 
Posts: 115
Default WHY IN EXCEL97 SUDDENLY GET 'EXCEPTION ERROR'

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 .




On Feb 4, 3:13 am, "Tom Ogilvy" wrote:
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.

--
Regards,
Tom Ogilvy

"CAPTGNVR" wrote in message

oups.com...

On Feb 4, 2:47 am, "Tom Ogilvy" wrote:
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.


--
Regards,
Tom Ogilvy


"CAPTGNVR" wrote in message


roups.com...


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.


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.