|
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. |
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. |
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. |
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. |
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. |
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. |
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. |
| All times are GMT +1. The time now is 01:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com