Results 1 to 4 of 4

Thread: Im confused
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2018
    Location
    Denmark
    Posts
    170
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Im confused

    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

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,912
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Im confused

    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 by Yongle; Aug 3rd, 2019 at 03:16 AM.

  3. #3
    Board Regular
    Join Date
    Jun 2018
    Location
    Denmark
    Posts
    170
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Im confused

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

  4. #4
    Board Regular
    Join Date
    Jun 2018
    Location
    Denmark
    Posts
    170
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Im confused

    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.....

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •