P Patrick C. Simonds Feb 21, 2008 #1 In UserForm Initialization, is there any way to have TextBox4 always show the value of cell A4?
J JLGWhiz Feb 21, 2008 #2 UserForm1.TextBox4.Text = Sheets(1).Range("A4").Value Change the UserForm name and Sheet as required.
UserForm1.TextBox4.Text = Sheets(1).Range("A4").Value Change the UserForm name and Sheet as required.
J JLGWhiz Feb 21, 2008 #3 Actually, in the Initialize event you don't even need to refer to the UserForm.