Re: Application.EnableEvents command Part 2

I don't know your real intent, but from the original message it would 
appear you want to disable a combo box and are hoping to do that by 
setting the EnableEvents to False.  That's overkill!  EnableEvents has 
substantial impact on XL communicating with your code (and other loaded 
add-ins).  Instead, consider something like
{ComboBox name}.Enabled=False

As far as the problem documented in the follow up message, consider 
moving away from automated triggers.  Why not have a button 'Update' 
that the user clicks after filling all the information?  That way, the 
person can enter the data in a manner that suits them -- the First Name 
first and the Last Name 2nd, or the reverse sequence.

Alternatively, if you insist on avoiding the 'Update' button, enable 
only one field at a time.  Suppose you start with the FirstName field.  
Then, use the Change event to enable the next field and disable the 
currently enabled field.  This will force the user to enter data in a 
pre-determined sequence.  The change event associated with the last 
field would complete the database update.

-- 
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[EMAIL PROTECTED]>, wewstv5
@yahoo.com says...
> Thank you for the help with my problem!
> 
>  Unfortunately I still don't have it licked.  To be more specific, I have
> code written in the CombBox Change event.  The combo box has two data fields
> in it, a first and last name.  To enter a new name to the database I have
> two text boxes.  When a new name is entered in the text box the change event
> for the combox box is triggered twice, once for the first name then again
> for the last.  There are sometimes in the program I do not want this event
> to trigger but still can't figure out how to do it.
> 
> My original message:
> 
> > I am writing an application in EXCEL 2000.   I have a combo box that I
> would
> > like to disable at certain times during the run of the program.  To do
> this
> > I used the "Application.EnableEvents = False" command.  The problem is,
> even
> > after using this command the combo box events are still triggering.
> Anyone
> > have any idea of why this wouldn't work?
> >
> > Chuck
> 
> Thank you in advance for any further help anyone can give me!
> 
> Chuck
> 
> 
>