Results 1 to 4 of 4

Thread: UserForm data to Worksheet and Save

  1. #1
    New Member
    Join Date
    Nov 2016
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default UserForm data to Worksheet and Save

    Hi all,
    Good day!

    I would like to ask for your assistance on this project that I am working. I have a UserForm that goes like this:



    I have a code in place in the 'Save Form' button that transfer the data from the UserForm to the Worksheet in the same file. The data is entered from Cell B9 to F9 but what I want is every time the user clicks 'Save Form' it would create a new line in B9 and at the same time Save the file. I just cannot figure out for the life of me how to do it.

    Here is my code:


    I hope that you can help me on this one and I would highly appreciate it

    Kind regards,
    Priv

  2. #2
    Board Regular
    Join Date
    Jul 2012
    Location
    Hampshire, UK
    Posts
    5,091
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    1 Thread(s)

    Default Re: UserForm data to Worksheet and Save

    Hi,
    If it is your intention to save each new record to Row 9 in your worksheet then see if following update to your code helps

    Code:
    Private Sub CommandButton1_Click()
        Const IRow As Long = 9
        Dim ws As Worksheet
    
    
        Set ws = Worksheets("Reports")
    
    
        ws.Rows(IRow).EntireRow.Insert
    
    
    'rest of code
        With ws
      
      
      
      
        End With
    
    
        ThisWorkbook.Save
    End Sub
    Dave

  3. #3
    New Member
    Join Date
    Nov 2016
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: UserForm data to Worksheet and Save

    Hi Dave,

    It worked as expected.
    I highly appreciate your time and effort on replying to this thread.

    Kind regards,
    Priv

  4. #4
    Board Regular
    Join Date
    Jul 2012
    Location
    Hampshire, UK
    Posts
    5,091
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    1 Thread(s)

    Default Re: UserForm data to Worksheet and Save

    Quote Originally Posted by privxls View Post
    Hi Dave,

    It worked as expected.
    I highly appreciate your time and effort on replying to this thread.

    Kind regards,
    Priv
    Most welcome - glad suggestion helped & thanks for the feedback.

    Dave

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
  •