• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1473
  • Last Modified:

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
0
progtw
Asked:
progtw
  • 2
1 Solution
 
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
 
mwharffCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now