VBA Checkboxes Hide/Unhide Rows - Rows are Moved Around - How to Easily Change References?

[kbohrer]

Hi there,

This may be a silly question and there may be an easy way to do this that I'm not aware of, as I am new to excel and VBA. I have a workbook that has multiple sheets. The first sheet is "fillable" in that it has a series of questions and the answers are then mapped to fill out forms on the rest of the tabs. There are also checkboxes on the first "fillable" sheet that reference rows in later tabs and these checkboxes hide/unhide the rows. On the forms that the answers are mapped to, I have had to make major changes and the result is that all the checkboxes are now referencing rows that don't contain what I want to hide/unhide. I am wondering if there is a quick, efficient way to get excel to recognize that these rows have been shifted around or a way to make changes quickly or if I need to go into each individual checkbox's VBA code and change the row numbers individually? Here's an example of the coding for a checkbox:

Please Login or Register  to view this content.

Because I'm a newbie, I may have set the checkboxes up in such a way that the only option is to go and change them all individually which is okay (not great, because there are ~80 affected boxes), but if that's the case and there's a better way to set them up please let me know. Thanks for any input/help!!

[maniacb]

There is no easy way to automate updating your code.