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

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

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