Hello,

I have a datetime picker on a userform. It works great as far as getting a
date from user.

However, after a date is selected, I check reservations for that date. I've
noticed that I need to add the same code to the dropdown event and the change
event for the datetime picker.

If the date is already on a the date for the next customer, the change event
won't fire. Therefore, I've added code to both drop down and the change.

But really, what I need is code to run after the user has selected a date.

Is there an event that tells me a date has been clicked on the pop up
calendar part of the datetime picker? That would be ideal.

Thanks,

Tony

Private Sub DTPicker1_CloseUp()
MsgBox "Selected"
End Sub

OR

Exit event after selection


If this post helps click Yes
---------------
Jacob Skaria


"Webtechie" wrote:

Hello,

I have a datetime picker on a userform. It works great as far as getting a
date from user.

However, after a date is selected, I check reservations for that date. I've
noticed that I need to add the same code to the dropdown event and the change
event for the datetime picker.

If the date is already on a the date for the next customer, the change event
won't fire. Therefore, I've added code to both drop down and the change.

But really, what I need is code to run after the user has selected a date.

Is there an event that tells me a date has been clicked on the pop up
calendar part of the datetime picker? That would be ideal.

Thanks,

Tony

Jacob,

That was exactly what I needed. I didn't even know of the event closeup.
WOW!

Thanks.

"Jacob Skaria" wrote:

Private Sub DTPicker1_CloseUp()
MsgBox "Selected"
End Sub

OR

Exit event after selection


If this post helps click Yes
---------------
Jacob Skaria


"Webtechie" wrote:

Hello,

I have a datetime picker on a userform. It works great as far as getting a
date from user.

However, after a date is selected, I check reservations for that date. I've
noticed that I need to add the same code to the dropdown event and the change
event for the datetime picker.

If the date is already on a the date for the next customer, the change event
won't fire. Therefore, I've added code to both drop down and the change.

But really, what I need is code to run after the user has selected a date.

Is there an event that tells me a date has been clicked on the pop up
calendar part of the datetime picker? That would be ideal.

Thanks,

Tony