VBA - Userforms and Dates

[Pacman52]

Hi all - its been years since I last had to create a userform or even touch VBA but I've been tasked with creating a workbook for my wife so that she can enter all her accounts data to make it easier for her to do her tax returns next year.

I've created an expense form - which so far works fine but I'm really struggling to work out an easy way for her to enter two dates on the form.
(Start Date - txtStart & End Date - txtEnd)

What I'd like to know is how do I code the two text boxes so that when data is entered it is automatically converted to the date format 'DD/MM/YYYY'
and once the dates have been entered I also need the number of days calculated with the result shown in another text box 'txtTotalDays' as a number i.e. if the start date is 10/10/2023 and the end date is 20/10/2023 the the total days would be 10. Once this form is submitted (by a button) the data populates the spreadsheet called 'Expenses'.

(On the spreadsheet I have formatted to relevent cells as a date).

I've been trying to work out how to do this now for two days and losing the will to live with google lol so would really appricate some advice please or a solution would be ideal !

Many thanks Paul

 

[Skyybot]

I named three Textboxes. sDate (TextBox1), eDate (TextBox2), and days (TextBox3). I used this code in the third (days) TextBox. I think it will do what you need. After start date (sDate) is entered, and end Date (eDate) is entered, and you click on (or Tab to) days box it will run.

Private Sub days_Enter()
Dim sDate As Date, eDate As Date, days As Integer
sDate = Me.sDate.Value
eDate = Me.eDate.Value
days = eDate - sDate
Me.days = days
End Sub

 

[Pacman52]

Many thanks for the reply Skyybot, I'll give that a try and hopefully it works for me

Paul

 

[Pacman52]

Hi again - just to confirm it works perfectly - thank you so much for taken the time to reply - thankfully I can now move forward with the forms design

Paul