Qn: Display Text in TextBox in Userform

[Michael Vaughan]

Hello Everyone,

I created a Userform with about 15 different Textboxes to input data. I
also have a checkbox option that allows the user to select if some of the
data will be repeated (ie: Place Check Mark here if numbers are the same).
Now, in my formulas, it works just fine. It will save the data from the
first 5 textboxes to the appropriate cells, and repeats the data to the new
cells like I want. Now, what I am looking for it to do is: When I enter my
numbers into the first 5 texboxes of the userform1, (and the data is to be
repeated); I place a check mark in the checkbox1, I would like the same data
DISPLAYED in the textboxes of the userform. I would like to see those
numbers in the userform itself. As it stands now, I place a checkmark and
the textboxes remain empty. But, it will write correctly to the appropriate
cells like I want it to. I would just like to see the data in the userform
before I hit "OK". Can somebody help me out with the VBA code on that??
Thanks in advance..mv

 

[Tom Ogilvy]

Private Sub Checkbox1_Click()
if Checkbox1.Value = True then
Textbox6.Value = Textbox2.Value
Textbox7.Value = Textbox2.Value
Textbox8.Value = Textbox1.Value
Textbox9.Value = Textbox3.Value
Textbox10.Value = Textbox3.Value
' as so forth
End if
End Sub