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
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
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies