Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1375
  • 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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