Excel VBA: DateTime Picker not firing the AfterUpdate event

Hi all,

I am using the DateTime Picker in Excel VBA. I place it on a form but when I use it to change a date it does not not fire the AfterUpdate event handler.

What I am doing wrong?

Avi
progtwAsked:
Who is Participating?
 
mwharffConnect With a Mentor Commented:
Probably your best bet is the Exit event.  I don't know all the options you're going to need would be to use the dtpicker1_Exit event.  This fires when the focus leaves the dtpicker.  The change event fires after every edit so it might get in the way if you're doing validation checking or using the date to fill in another listbox.
0
 
JefKveCommented:
Is ther anything in the beforeupdate event that might keep afterupdate from occuring?

jeff
0
 
mwharffCommented:
There doesn't seem to be a beforeupdate or afterupdate event.  Try using a combination of Exit and or change events.

Hope this helps.

Mike
0
 
progtwAuthor Commented:
To mwharff:

>> Try using a combination of Exit and or change events.

Can you clarify>

tia

Avi
0
All Courses

From novice to tech pro — start learning today.