Home

Dropdown list of students

%3CLINGO-SUB%20id%3D%22lingo-sub-755707%22%20slang%3D%22en-US%22%3EDropdown%20list%20of%20students%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-755707%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%26nbsp%3B%20I%20am%20attempting%20to%20create%20a%20sheet%20where%20I%20have%20a%20list%20of%20students%20in%20a%20dropdown%20menu%20(the%20names%20are%20being%20auto-populated%20from%20another%20sheet)%3B%20the%20rest%20of%20the%20sheet%20has%20checkboxes%20with%20a%20formula%20that%20adds%20up%20how%20many%20checkboxes%20are%20checked.%3C%2FP%3E%3CP%3EI%20am%20able%20to%20choose%20a%20student%20name%2C%20check%20off%20boxes%2C%20and%20have%20that%20total%20automatically%20populate%20on%20a%20different%20workbook.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EBut%20now%20I%20want%20to%20choose%20a%20new%20name%20from%20the%20dropdown%2C%20and%20for%20the%20checkboxes%20to%20go%20back%20to%20blank%2C%20and%20for%20the%20new%20total%20to%20populate%20in%20the%20corresponding%20student's%20cell.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EI'm%20not%20even%20sure%20if%20that%20can%20be%20done.%26nbsp%3B%20Any%20ideas%20would%20be%20a%20great%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-755707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-755952%22%20slang%3D%22en-US%22%3ERe%3A%20Dropdown%20list%20of%20students%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-755952%22%20slang%3D%22en-US%22%3EHi%20jensuso%3CBR%20%2F%3E%3CBR%20%2F%3EDo%20you%20have%20any%20experience%20with%20writing%20VBA%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20would%20need%20to%20write%20a%20routine%20that%20would%20capture%20the%20total%20against%20the%20student%20and%20then%20clear%20all%20check%20boxes.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20could%20start%20by%20using%20the%20Macro%20Recorder%20to%20capture%20the%20code%20that%20is%20created%20when%20manually%20performing%20the%20actions%20you%20want%20to%20perform%20and%20then%20amending%20the%20code%20to%20make%20it%20repeatable.%20This%20is%20not%20a%20simple%20task.%3C%2FLINGO-BODY%3E
jensuso
Occasional Visitor

Hello.  I am attempting to create a sheet where I have a list of students in a dropdown menu (the names are being auto-populated from another sheet); the rest of the sheet has checkboxes with a formula that adds up how many checkboxes are checked.

I am able to choose a student name, check off boxes, and have that total automatically populate on a different workbook. 

But now I want to choose a new name from the dropdown, and for the checkboxes to go back to blank, and for the new total to populate in the corresponding student's cell.

I'm not even sure if that can be done.  Any ideas would be a great help.

1 Reply
Highlighted
Hi jensuso

Do you have any experience with writing VBA ?

You would need to write a routine that would capture the total against the student and then clear all check boxes.

You could start by using the Macro Recorder to capture the code that is created when manually performing the actions you want to perform and then amending the code to make it repeatable. This is not a simple task.
Related Conversations
grades in teams
massi7762 in Microsoft Teams on
0 Replies
SharePoint Lists - Expanded View Roadmap ID: 57302
Kotus-Tech in SharePoint on
9 Replies
Multi-value fields display no separator
Florian Hein in SharePoint on
1 Replies
Excel ComboBox (ActiveX Controls) dropdown not functioning
Kpizzle in Excel on
1 Replies
SharePoint List Drag item Move error
mvas111 in SharePoint on
0 Replies
SPO list jumps to top when loading new items
ABehrens in SharePoint Developer on
1 Replies