Userform that is filled out when it opens

[Even]

Hi, I have finally managed to create a working userform (after many, many hours) ? However, whenever I open the userform all textboxes are empty. Is it a way for textboxes to be filled out with values from the cells that I will update?
There are approx 30 boxes and most of the times I just need to update a couple of values. And when I let the boxes be empty and click ok, it deletes the values in the cell - which sucks.

So it would very helpful to have it filled out and I can just update the ones that I want.

Thanks,

Even

 

[mumps]

You can do what you want by doing a little research into UserForm_Initialize. This will allow you to fill the text boxes every time you open the userform.

 

[My Aswer Is This]

Try something like this:
Modify as needed
Put this script in your Userform

Private Sub UserForm_Initialize()
'Modified  6/5/2021  11:09:25 AM  EDT
TextBox1.Value = Sheets("Alpha").Range("A1").Value
TextBox2.Value = Sheets("Bravo").Range("G1").Value
End Sub

 

[Even]

Thanks, I will try it out