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