error handling
in [Programming]
|
Prev: distribution problems; users don't have this and misc
Next: Print Preview allows margin change in protected sheet
From: Dawna on 17 Dec 2009 21:25 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
From: Patrick Molloy on 18 Dec 2009 05:50 use the Application.OnKey method "Dawna" <Dawna(a)discussions.microsoft.com> wrote in message news:30937625-50D4-4796-AB94-21EEA34F48EA(a)microsoft.com... > 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
From: Dawna on 18 Dec 2009 09:06
Thank you Patrick "Patrick Molloy" wrote: > use the Application.OnKey method > > "Dawna" <Dawna(a)discussions.microsoft.com> wrote in message > news:30937625-50D4-4796-AB94-21EEA34F48EA(a)microsoft.com... > > 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 > |