Im confused

[Hjemmet]

I have in first place ask for help about how to get value’s from cell
to labels on Userform and get help for that

and in second ask for another Function on userform to copy
value’s from labels on user form to a new sheets

two different Question can be a Double Question

 

[Yongle]

how to get value’s from cell to label on Userform

Private Sub UserForm_Initialize()
    Label1.Caption = Sheets("Data").Range("A10").Value
End Sub

Function on userform to copy values from labels on user form to a new sheet

Private Sub CommandButton1_Click()
    With Worksheets.Add
        .Range("A5") = Label1.Caption
        .Range("A10") = Label2.Caption
    End With
End Sub

 

[Hjemmet]

Thanks for you help i take a look on after today’s turnament in Dart

 

[Hjemmet]

I have now look't at your code

and it's seems to work But as always there is a BUT

with your code i need to make alot's of Userform's for each Game in Cupsystem

right now i have Only one Userform wich is change data each time a Combobo is change the selection on
wich game to take action on.....