Textbox datwe auto update

[Patriot2879]

Hi good morning, I have the code below which is in my textbox, but it doesn't auto update,can you help me please?

Private Sub TextBox10_GotFocus()
If Me.TextBox10.Value = "" Then
   Me.TextBox10.Value = Format(Date, "dd/mm/yyyy")
 End If

End Sub

 

[Patriot2879]

no not found it yet Im googling to find some screenshots

 

[Patriot2879]

OMG I am still struggling with this so sorry,

 

[silentwolf]

Did you see my link on post#10 ?

Open this and you will see..

 

[Patriot2879]

I tried that thank you for the link, I don't suppose I could send you the file?

 

[silentwolf]

So you are not able to get this to work?
You know how to get into the VP Editor right? if not by pressing ALT+F11
Then you doppel click the worksheet on the left hand side where you like your code to run "Sheet1" or what ever..
Then you look at my post my link scrol down and at the first picture you see there is exactly what you neet to do.!