Date/Time Picker Event Won't Fire

  • Thread starter Thread starter Mark Driscol
  • Start date Start date
M

Mark Driscol

I thought someone in this group might know the answer to this. Perhaps it
is close enough to any problems that may occur in Outlook that someone will
know. I didn't get a response from the Excel programming group.

Excel 2003, Windows XP

I am using the Date/Time Picker in a UserForm. The Change event will fire,
but neither the BeforeUpdate nor the AfterUpdate events will fire after
changing a date. Does anyone know why?

Thanks in advance.

Mark
 
In Outlook forms at least there is a limitation on which events will fire
and can be sinked. Change is the one that works.
 
Those events that you speak of have to do with Before you
enter the cell and after you leave the cell......they deal
more with the FOCUS side of things, meaning that if you're
in 1 cell and move to another then the FOCUS has shifted
and if there is a Before Update event for that instance it
will fire, same on the back end with After Update.

The change event occurs wether you enter/leave/update the
cell.

I believe this is correct right MVPs?
 
Back
Top