Thread: UserForm auto refresh/update
View Single Post
 
Old 05-27-2021, 12:11 AM
JamesWood JamesWood is offline Windows 10 Office 2019
Advanced Beginner
  
Join Date: Nov 2020
Posts: 37
JamesWood is on a distinguished road
Default
Quote:
Originally Posted by Guessed View Post
The OnChange event does this
Code:
Private Sub DateBox_Change()
  Me.FileNamePreview.Value = "Letter to " & Me.DateBox
End Sub


That's amazing, thank you so much!
Reply With Quote