Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error handling
Is it possible to assign a specific key (such as INS) for error handling? I
have a combobox that pulls data from a list in sheet2. If the Item is not in the list, I would like the user to be able to press the INS button to call the code to add the item. Thank you in advance Dawna |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
error handling
use the Application.OnKey method
"Dawna" wrote in message ... Is it possible to assign a specific key (such as INS) for error handling? I have a combobox that pulls data from a list in sheet2. If the Item is not in the list, I would like the user to be able to press the INS button to call the code to add the item. Thank you in advance Dawna |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
error handling
Thank you Patrick
"Patrick Molloy" wrote: use the Application.OnKey method "Dawna" wrote in message ... Is it possible to assign a specific key (such as INS) for error handling? I have a combobox that pulls data from a list in sheet2. If the Item is not in the list, I would like the user to be able to press the INS button to call the code to add the item. Thank you in advance Dawna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
First Error works but Subsequent Error Handling Does Not | Excel Programming | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Set Error handling INSIDE error-trap | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error handling with a handling routine | Excel Programming |