Excel Forms Help

MyiagrosMyiagros Registered User regular
My GoogleFu is failing me with the proper keywords on this, I've only found the method for Access but it isn't very helpful for Excel.

I've thought of doing an Access Database in the past for stat keeping for my hockey league which I've looked for assistance with before. This time however I'm looking to make the initial score keeping easier, basically moving away from paper. Easiest way I can think of without having to program anything crazy is to use Forms inside Excel(which I'm currently using for tracking) that can be edited from a tablet, then saved/uploaded to OneDrive.

I'm currently stuck on how to have text boxes fill with data based on what is selected in a Combobox. Example:

A B C
Dec 1 Team1 Team4
Dec 2 Team2 Team5
Dec 3 Team3 Team6

Combobox contains the Date range selection, I want to select the date from the list and have the text boxes below it fill the Teams that are playing. Doing the date is easy but I'm missing the step on how to link the other columns to the date without having to do a huge IF statement(there are 90 games per year). I'm also planning on doing something similar for the goals/assists that links to other columns would be nice to use.

I'll probably run into more things I'll have questions about but this is a start.

iRevert wrote: »
Because if you're going to attempt to squeeze that big black monster into your slot you will need to be able to take at least 12 inches or else you're going to have a bad time...
Steam: MyiagrosX27

Posts

  • SmrtnikSmrtnik job boli zub Registered User regular
    What you want is the lookup function (or one of its offshoots). You set up a table elsewhere on the sheet (or another sheet), then in the cell where you want to fill in the text box you were in the lookup function to refer to the pulldown vs that lookup table.

    steam_sig.png
  • The Big LevinskyThe Big Levinsky Registered User regular
    Couldn't you just turn on the Auto-Filter for the date column? That would allow you to pick a date or dates from the filter drop down and see exactly what teams are playing.

  • HefflingHeffling No Pic EverRegistered User regular
    Assuming you have F6 as your date entry, you want:

    Vlookup(F6,A1:C3,1) and Vlookup(F6,A1:C3,2) which will look up the values based on what is entered in F6 against column A, and the "1" and "2" tell it how many columns to the right of A to find the corresponding value.

    If a movement doesn't have someone that can sit down opposite those in a position of power and strike a deal, how can that movement achieve success?
  • MyiagrosMyiagros Registered User regular
    Awesome, thanks guys, I'll try that out.

    iRevert wrote: »
    Because if you're going to attempt to squeeze that big black monster into your slot you will need to be able to take at least 12 inches or else you're going to have a bad time...
    Steam: MyiagrosX27
Sign In or Register to comment.