I have quite a few rows with a checkbox on each row. When the checkbox is clicked I perform a few actions within a few columsn on that row. Instead of hardcoding each row number into the code, is there a way to grab the row number that the checkbox is located?
Here's what I have now on row 205, for example.
Me.Range("C205:I205").Font.Color = RGB(75, 75, 75)
And it'd be nice to put that action on each checkbox, but without hardcoding the row number and keeping the columns (C and I) the same.
Thanks!
Bookmarks