Thread: UserForm auto refresh/update
View Single Post
 
Old 05-26-2021, 05:28 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
The OnChange event does this
Code:
Private Sub DateBox_Change()
  Me.FileNamePreview.Value = "Letter to " & Me.DateBox
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote