need a vba code worksheet that go into a form

TLS49

Board Regular
Joined
Nov 26, 2019
Messages
132
Office Version
  1. 365
Platform
  1. Windows
SCREENSHOTS.jpg
SCREENSHOTS2.jpg

have a NFL schedule program was made. I have worksheet that is call BYE WEEK. I have Userform that have comobox with weeks 1-17 and list all 32 NFL Teams names side to it 32 textbox. when I change weeks 1-17. It should match what are in BYE WEEKS worksheet. How get this working?

Press button that said form Input Scores Into Worksheet to open the form. when you press send score into input_score worksheet will be visible

Copy data from worksheet into form

DOWNLOAD NFL SCHEDULE FILE


Thanks You

TLS49
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
look at bye team worksheet. look at BYE name of team. open input scores form drop down have 1-17. on form look at by team worksheet put BYE without remove any data other textboxes
 
Last edited:
Upvote 0
I go to the "BYE WEEK" sheet. I click on the button to Open the forms. when I select the week (example week 10) the 3 teams (Chiefs, Cowboys & Falcons) all get populated with the word "BYE".
It appears to work for me no matter chick week I pick.
 
Upvote 0
look at Image. there drop down 1-17 look at bye team work. put BYE without removing any data in other textboxes
 

Attachments

  • SCREENSHOTS03.jpg
    SCREENSHOTS03.jpg
    153.8 KB · Views: 9
Upvote 0
Is the issue that you have all the scores in for week 8 and then when you pick week 8 from the drop down that is erases all the scores?
 
Upvote 0
no keep all score in place. when I pick 1-17 show who have bye team for that week in form
 
Upvote 0
sorry, I don't understand. I guess i can't see the tree thru the forest. I'm sure the solution is simple
 
Upvote 0
create vba code do put BYE in textbox lookup from bye teams worksheet without deleting other textbox have score
 
Upvote 0
Hi, you want to change using VBA code the BYE word in this sheet, considering what?

Book1
ABCDEFGHIJKLMNOPQR
1TEAMS1234567891011121314151617
249ERS20313620172433
3BEARS27173011202310
4BENGALS1330233332734
5BILLS27313530161718
6BRONCOS14211037BYE1816
7BROWNS635344932737
8BUCCANEERS23312838193845
9CARDINALS24302321303837BYE
10CHARGERS1620163127BYE39
11CHIEFS34233426322643
12COLTS202836192331BYE
13COWBOYS1740313837103
14DOLPHINS112831234324BYE
15EAGLES17192325292822
16FALCONS25392616164022
17GIANTS161399342021
18JAGUARS27301325141629
19JETS171372810010
20LIONS23212629BYE3423
21PACKERS43423730BYE1035
22PANTHERS30172131231624
23PATRIOTS21303610BYE126
24RAIDERS3434202340BYE20
25RAMS20373217301624
26RAVENS383320312730BYEBYE
27REDSKINS27152017101925BYE
28SAINTS3424303530BYE27
29SEAHAWKS3835383127BYE34
30STEELERS262628BYE383827
31TEXANS20162123303620BYE
32TITANS163331BYE424224
33VIKINGS341130312623BYE
INPUT_SCORES
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B2:R34Cell Value="BYE"textNO
B2:R34Cell Value>$Z$1textNO
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,198
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top