macro to populate list/combo box, then delete selected sheet and rows on other sheets

Hello all. With a lot of help, I believe I have the necessary code to add new member sheets and rows on established sheets. Now I would like a macro to have a list/combo box automatically populate with the names (first and last) on the Scout totals sheet, then delete the selected member from the Counts sheet, the Scout Totals sheet, and finally delete the member's sheet from the workbook. This will make it very simple to reuse it every year when the older members move on and need to be removed from the workbook.

Thanks in advance for your assistance!!

Andrew

Hi Andrew

I'm working on the logic of your workbook and have a question.

Why are there names in Scout Totals that don't appear in Counts? There are 18 names (including 0...by the way, what is 0) in Scout Totals and only 14 names in Counts.

John

Hi Andrew

Try the attached. I believe it does as you described. Let me know of issues.

John

Hi Andrew



I replaced your Form Control Button with an ActiveX Control Button. Assuming you're using Excel 2007 (as your profile indicates):

• Developer -> Insert -> ActiveX Control
• Right Click on the Button to see your options (Properties, View Code, etc.)
• Or, simply Copy -> Paste the button then Right Click

I assume this is what you're asking.

John