+ Reply to Thread
Results 1 to 4 of 4

Grabbing Data From a UserForm and Putting it Into A Sheet Help Please.

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    Really
    MS-Off Ver
    Excel 2007
    Posts
    25

    Grabbing Data From a UserForm and Putting it Into A Sheet Help Please.

    So below is a picture of my userform.

    cows.jpg

    There are three things I wish to do with this. The first is attach it to a button on my first sheet of the workbook. That way when I click the button it will pull up the userform. How do I do this?

    The second thing I want to do it have the data that will be input into the right column of boxes copied into other cells onto the spreadsheet. For example, if a user entered a different number of cows, say 150 for example, I want that number to appear in cell C3 of sheet 2. Then if the value were changed to 75 or any other number, the number in the cell C3 of sheet 2 should change as well. I wish to do this will all my numbers in the right column but they will be inserted into different parts of the workbook. For example the current breeding costs per calf should be input into cell D8 of sheet 2 of the workbook. How do I specifically select where each number in the right column gets inserted into the workbook?

    The last thing I want to do is have the button on the bottom left (Click here to move on) transfer me to sheet 3 of the workbook.

    Any help with any or all three of these functions is greatly appreciated.
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Grabbing Data From a UserForm and Putting it Into A Sheet Help Please.

    attach please the xlsm file
    If solved remember to mark Thread as solved

  3. #3
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Grabbing Data From a UserForm and Putting it Into A Sheet Help Please.

    see this simple example: Userform.xlsm

    The value from the textbox will be written into the active sheet when you click the button on the form.
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  4. #4
    Registered User
    Join Date
    02-10-2013
    Location
    Really
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Grabbing Data From a UserForm and Putting it Into A Sheet Help Please.

    Got all 3 situations solved. Thank you for your help. The example userform was very helpful.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1