Forum Discussion
i need help code worksheet to userform without type in manually.
I have a worksheet called Bye weeks. I also have a user form called NFL Scores form. I help create VBA code to look at the bye week worksheet and also look on user form team bye which match on ...
Open the VBA editor (Alt + F11).
Insert a new UserForm named NFL_Scores_Form.
Add a ComboBox (ComboBoxTeams) and a Label (LabelByeWeek) to the UserForm using the toolbox.
Copy and paste the code from above into the UserForm code window and a standard module to handle showing the form.
You can run ShowNFLScoresForm to open the UserForm from anywhere in your workbook.