creating a chart from a userform

You don't need a userform for this.

You can use a worksheet.
See attached.
On Sheet2 cells B1:B3 use different drop down lists to select player, course and hole.

A macro is assigned to a command button. Drop down selections are passed as filter criteria for filtering the data table on Sheet1.
Dates and scores from the matching hole are copied to Sheet2.

Lists were set up on sheet3 and are used in the DV drop down.

On Sheet1, I suggest you use drop down selections for players and courses to avoid issues with typographical errors that can cause the code to fail.

This is basic code, not much error handling beyond testing for blanks in the drop downs.

Please Login or Register  to view this content.

Excel Help _807056.xlsm

A user form is not a requirement and, IMO, not needed. It is simpler to go with populating cells in a worksheet.

However, if you intend to allow multiple holes to be selected then you would need a different approach for hole selection(s). Data validation allows only one selection.

imo= in my opinion

I would use Data Validation drop down list - not the combo box controls. This is what I modeled the code on. It will require significant changes to adapt to using controls.
The drop down list for the holes was set by create a named range referring to the range of cells E1:V1 on sheet1 of the example file.

Since these are fixed values that will not change, you could just type the list in to the list source for the Data Validation.

If you want to include any combination of holes, then try using Marlett check boxes

Modified code below and now includes additional code to use Marlett check boxes in the worksheet selection change event.

Worksheet code:

Please Login or Register  to view this content.

Code modified to use the selections for multiple holes:

Please Login or Register  to view this content.

Also, you may want to clear the selection in one go to start fresh.

Please Login or Register  to view this content.

Excel Help _807056.xlsm