Combo Box from list and getting table to populate

Is the Loop statement in the wrong place?

Please Login or Register  to view this content.

Forgive me. But I'm graphically challanged.

1. You were assigning the Student named range just to a range. Not to the named Range.

a. You had the changed event named wrong. It should have been just Private Sub Combobox21_Change. While this worked, the combobox was updating after the selection of a name. That should happen BEFORE you select a name from the Combobox, so I moved the code to the Worksheet_Activate event. Now, the code fires whenever you activate the sheet.

2. [Load and Graph] I don't work in Selection much, so I changed all the Activecell references to Range. I hope this isn't too much of a burden on you.

the button text gets progressively larger as its clicked)

Hmm. I doesn't do that on either of my machines.

If you want the graph to update after selecting the name from the combobox, move all the code from the Commandbutton21_Click event to the Combobox_click_event.

Anytime you select another sheet, then move back to the Student Report sheet, the combobox is automatically updated.