Hi
I want when write day of date ,then will fill the current month & current year automatically without I enter manually .
for instance if I have textbox1 on userform , and write day "23" then will fill automatically like this 23/01/2023
I have this but is useless
I hope this is sens .
I want when write day of date ,then will fill the current month & current year automatically without I enter manually .
for instance if I have textbox1 on userform , and write day "23" then will fill automatically like this 23/01/2023
I have this but is useless
VBA Code:
Private Sub TextBox1_Change()
TextBox1.Text = Format(TextBox1.Text, "dd/mm/yyyy")
End Sub