User Form day name from date

[FlashNZ]

I have built a user form and I have DTPicker1 where the user can select a date. I have a text box called tbSearchDay that I would like it to automatically display the day of the week once a date is selected in DTPicker1.

How to make this happen, thanks in advance?

Gordon

 

[Micron]

Perhaps in textbox AfterUpdate event

If Not Me.DTPicker = "" Then tbSearchDay = Format(DTPicker,"dddd")

You might require other validation such as ensuring the entry is a valid date. Results might depend on which date format you're using - US or not.

 

[FlashNZ]

Perhaps in textbox AfterUpdate event

If Not Me.DTPicker = "" Then tbSearchDay = Format(DTPicker,"dddd")

You might require other validation such as ensuring the entry is a valid date. Results might depend on which date format you're using - US or not.

Thanks, it works, nearly. If I select a date in DTPicker1 then nothing appears in tbSearchDay until I enter a value into tbSearchDay it then shows the day of the week correctly. How do we make this happen automatically?

 

[Micron]

Post your code so I have something to look at? Please use code tags (vba button on posting toolbar).

 

[FlashNZ]

Here is the code:

undefined

 

[FlashNZ]

Sorry here it is:

Private Sub tbSearchDay_AfterUpdate()
If Not Me.DTPicker1 = "" Then tbSearchDay = Format(DTPicker1, "dddd")
End Sub

 

[Micron]

If I select a date in DTPicker1 then nothing appears in tbSearchDay until I enter a value into tbSearchDay

Until you posted the code I had no real idea if you were using the right event or not. So you actually have to start entering something in the textbox that you want the code to update? That sounds like the update event isn't firing as desired. If you pick a date and it goes into the date textbox, will the other one not show the day value when you click out of the date textbox? Perhaps click into some other control or on the form itself to test.

 

[FlashNZ]

Until you posted the code I had no real idea if you were using the right event or not. So you actually have to start entering something in the textbox that you want the code to update? That sounds like the update event isn't firing as desired. If you pick a date and it goes into the date textbox, will the other one not show the day value when you click out of the date textbox? Perhaps click into some other control or on the form itself to test.

Hi, it appears from looking online it is an issue with the Date Picker control. I created a text box and if I refer to that text box and enter a date into it updates the day automatically.

Thanks for your help.

 

[Micron]

Ahh, so I'm familiar with the date picker option in an Access textbox and assumed it would be the same in Excel. Silly me to think that 2 divisions of M$ might be on the same page with features. In Access, if you elect to show date picker for dates, whatever you choose from the calendar picker that pops up goes right into the textbox.
Glad you figured it out.