UserForm auto refresh/update

[JamesWood]

Hi guys




I'm designing a UserForm which has two TextBoxes. I'm wondering if the second textbox can reflect the changes made to the first text box, in real time?


See the attached image.


So the first userform is DateBox, and second is FileNamePreview. The DateBox userform defaults to showing today's date, but if the user then decides to alter that date, I want it to reflect automatically in the FileNamePreview form.


With Me.DateBox
.Value = Format((Year(Now() + 1) Mod 100), "20##") & Format((Month(Now() + 1) Mod 100), "0#") & Format((Day(Now()) Mod 100), "0#")
End With


With Me.FileNamePreview
.Value = LetterTo & docNameFieldPreview & " " & Me.DateBox.Value
End With


Thanks a lot
James