Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Load data from worksheet into Userform
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,810
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    13 Thread(s)

    Default Re: Load data from worksheet into Userform

    And you have this code in a Button on your Useerform.

    Why not show me all the code like.

    Private Sub CommandButton1_Click()
    And you code here
    End Sub
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  2. #12
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,810
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    13 Thread(s)

    Default Re: Load data from worksheet into Userform

    I suspect you do not have the sheet named exactly like this.
    Or maybe the sheet is protected

    Or Your Textbox does not have that exact name

    Everything must be exact.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  3. #13
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,123
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Load data from worksheet into Userform

    Which line of code gets highlighted if you click debug?
    The 424 error means that one of those textboxes doesn't exist.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  4. #14
    New Member Nitehawkhp's Avatar
    Join Date
    Dec 2016
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Load data from worksheet into Userform

    Mystery solved!!

    I had the code under the area (I don't know if this is the correct terminology), on the userform it was placed under the "Click" area and not the "Initialize" area.
    Once I moved the code to the initalize area it worked perfectly.

    Happy to have this mess fixed.

    Thank you to all who provided help and ideas to solve this mystery. Sleeping on it and having a fresh look at things allowed me to find the mistake.
    Also, I looked at another userform and noticed the error.

    Thanks again,

    Rod

  5. #15
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,123
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Load data from worksheet into Userform

    Glad you sorted it out & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

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
  •