Forum Discussion
Initializing TextBoxes within a UserForm
My spreadsheet contains a macro which utilizes two UserForms, each containing several TextBoxes. I want to initialize several TextBoxes in each Userform. One UserForm works and the other one does n...
How you are executing the codes? I means which event? This works fine to me with UserForm_Activate event.
Private Sub UserForm_Activate()
Me.TextBox1.Value = "MyValue"
End Sub
I have tried to use the reply you gave me, but I was not successful.
I have reduced my problem into the simplest of terms to illustrate my problem, but I don't know how to attach the file to this reply. Give me your email address and I can send it to you.
I tried your solution again and this time it worked, and I'll use it. I still don't know why my method failed because I have been using it for years. Anyway, thanks.
You can message privately here.