Unanswered: coding to activate a cell with a control in it
I am creating a checklist of subsystems and applications. I am using checkboxes with the names of our major subsystem and application next to the checkboxes. When a user clicks the checkbox next to one of the main subsystems, I have coded the sheet to add cells directly below that particular subsystem, and fill the cells in with the names of associated subsystem, databases, and applications.
My problem is in referencing the location to add the new cells. I want them directly under a specific subsystem name, but that subsystem changes location whenever more cells are added. (It drops further down the list).
I thought I could do a find for the name of the subsystem associated with the checkbox, and then activate the cell containing the checkbos so I can finally have the cells inserted under whichever cell that turns out to be. Would this be the best way to achieve this???