OK, I give up. After trying to figure this out over several days, I turn to the experts.

I am using Excel 2002. I have a Combobox linked to each Cell in Range M6:M34 (29 ComboBoxes). I need a Macro that will make only the ComboBox that is linked to the currently selected Cell in that range (M6:M34) be 'Visible = True'. All others will be 'Visible = False'. As subsequent Cells are selected (M6, M7, M8, M9...), I can run the Macro to set the ComboBoxes accordingly

Thanks for the help.
justdave7