Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WHY IN EXCEL97 SUDDENLY GET 'EXCEPTION ERROR'
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
WHY IN EXCEL97 SUDDENLY GET 'EXCEPTION ERROR'
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 ups.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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
WHY IN EXCEL97 SUDDENLY GET 'EXCEPTION ERROR'
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 ups.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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
WHY IN EXCEL97 SUDDENLY GET 'EXCEPTION ERROR'
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 ups.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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
WHY IN EXCEL97 SUDDENLY GET 'EXCEPTION ERROR'
This will unselect all items
with listbox1 for i = 1 to .listcount - 1 .selected(i) = False next i End With -- Regards, Tom Ogilvy "CAPTGNVR" wrote in message oups.com... 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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
WHY IN EXCEL97 SUDDENLY GET 'EXCEPTION ERROR'
On Feb 4, 4:32 am, "Tom Ogilvy" wrote:
This will unselect all items with listbox1 for i = 1 to .listcount - 1 .selected(i) = False next i End With -- Regards, Tom Ogilvy "CAPTGNVR" wrote in message oups.com... 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 groups.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. THANK YOU TOM. It works. Finally i got the answer and thread is closed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Excel Error - Win32 exception | Setting up and Configuration of Excel | |||
WHAT ARE THE CAUSES FOR 'EXCEPTION ERROR ' | Excel Discussion (Misc queries) | |||
Unhandled Exception Error | Excel Programming | |||
Protect Error Excel97 | Excel Programming | |||
Exception Error? What is it? | Excel Programming |