Grabbing the current row number

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.

Please Login or Register  to view this content.

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!

Attached is an example of what I'm doing.

TopLeftCell.Row works great. However, a quick question. Currently my functions on each checkbox looks a little like this...

Please Login or Register  to view this content.

What can be used to substitute the checkbox name? In this case "Ach_CorrectFirmware". (Something along the lines of This in other languages.)

Originally Posted by shg

I would agree with JP about not using ActiveX controls on a worksheet, but I wouldn't use Forms toolbar checkboxes either. Marlett checkboxes are easy to mechanize, and you don't have to worry about where objects are on the drawing layer, because they are just cells.

Never heard of Marlett checkboxes and can't seem to locate them in Excel. Where can I find the control?

Originally Posted by JosephP

you're using activex controls-you'd need a class to do that. forms controls are simpler and more stable-you can just assign the same macro to all of 'em at once.

How can I generically call the checkbox that's being clicked using a common function? For example, if I want to make a function to highlight the row of the checkbox I don't want to hardcode each row number or a separate function for each box.

Originally Posted by JosephP

if you replace the activex controls with Forms versions, you can assign them the same macro and then use the code I posted before

Gotcha. Forgot about that post. Thank you.