Listbox macro to hide/unhide rows in different sheet

VBA neophyte talking here..... in the attached abbreviated example, what should the second line in each of the three macros read to direct the hiding/unhiding of rows in the adjacent sheet? Right now I'm trying a If/Then configuration but it's not working. With clabhart's help I was able to figure this out using grouped check boxes but a list box should be graphically "cleaner" and hopefully simpler in coding. The original table list is hidden in column "A", if that is important. I could use a combo box but the menu list is short and I think the list box approach will be simpler.... If there is a way to combine the three macros into one, that also would be helpful.

Thanks for your help, I need it! David

Not a bad attempt for a "neophyte".

Try this:

Please Login or Register  to view this content.

Make sure to place this code under the Sheet1.
You can do this by right-clicking on the Sheet1 tab and selecting "View Code".
Let me know if you have any questions.

This works, however, I cannot see the macro listed. In fact, there are no macros listed, which concerns me as I would like to be able to name these. I will need to perform this same operation about 40-50 times in Sheet 1 (which I will need to title "Scorecard" in my real application), with other groups of rows again hidden/unhidden in the "Tasks" sheet. How should I adjust this macro to accomodate these criteria?

Thank you for help!

The Needy Neophyte