lcjohnson
02-11-2015, 11:32 PM
I'm wanting to create a userform that will collect course name, tee box and 18 individual hole scores, then once the submit button is pressed that information will be entered to the worksheet.
If you open the file you will see i have formulas in the fields to calculate date/entry#/scoretotal once the userform submits information to worksheet.
If you open the visual basic editor you will see the userform I have created. It's very basic and simple. 2 combo boxes and 18 text boxes, with a submit and close button.
I believe all I need to complete this little project is to code the userform to add the information to the worksheet when the submit button is pressed. And lastly, add a button to the worksheet to prompt the userform to open.
You can find the information I would like the two combo boxes to contain in the worksheet to the side. (Course Names/Tee Boxes) The text boxes will contain numbers depending on what each holes score is.
If you open the file you will see i have formulas in the fields to calculate date/entry#/scoretotal once the userform submits information to worksheet.
If you open the visual basic editor you will see the userform I have created. It's very basic and simple. 2 combo boxes and 18 text boxes, with a submit and close button.
I believe all I need to complete this little project is to code the userform to add the information to the worksheet when the submit button is pressed. And lastly, add a button to the worksheet to prompt the userform to open.
You can find the information I would like the two combo boxes to contain in the worksheet to the side. (Course Names/Tee Boxes) The text boxes will contain numbers depending on what each holes score is.