UserForm auto refresh/update

JamesWood · #1 05-26-2021, 06:24 AM

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

Guessed · #2 05-26-2021, 05:28 PM

The OnChange event does this

Code:

Private Sub DateBox_Change()
  Me.FileNamePreview.Value = "Letter to " & Me.DateBox
End Sub

JamesWood · #3 05-27-2021, 12:11 AM

Quote:

Originally Posted by Guessed

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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto-refresh pivot table without losing undo buffer	Peterson	Excel Programming	0	03-25-2020 06:56 PM
Can't update/refresh embedded Excel file with Power Point 2010 command button	mt1013	PowerPoint	0	06-17-2015 05:18 AM
Update Bookmarks from a Userform	alshcover	Word VBA	12	01-12-2015 06:53 PM
Auto Refresh Pivot Table on Timer	bremen22	Excel	2	10-01-2013 01:00 AM
VBA code to update record in Access 2003 using Userform in Excel	primmer3001	Excel Programming	0	08-29-2011 04:25 PM