Im confused

Hjemmet

Board Regular
Joined
Jun 20, 2018
Messages
207
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
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
how to get value’s from cell to label on Userform
Code:
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
Code:
Private Sub CommandButton1_Click()
    With Worksheets.Add
        .Range("A5") = Label1.Caption
        .Range("A10") = Label2.Caption
    End With
End Sub
 
Last edited:
Upvote 0
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.....
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top