How to target the row that the button that has been clicked is in.

[Oriya]

Hi all,

I'm working on a sheet where I want the button when it is clicked to hide the current row and show the next one (that is already hidden). At the moment I am doing it by creating a macro for every single row.
For example:

Please Login or Register  to view this content.

What i'd like to do is to have just one bit of code I can apply to every button that does the above but a generalised version (at the moment I've got 3 bits of code per row and i'm up to 20. I'd love not to have to copy/paste and change the numbers!).

I managed to find a way to target the current row if the mouse has selected a cell in that row BUT not if the button in that row is clicked.

Anyone any thoughts?

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Oriya]

Sorry I didn't realise! All changed.

[Fluff13]

How about

Please Login or Register  to view this content.

[Oriya]

Thank you so much Fluff13, that is amazing! This saves me so much work!

[Fluff13]

You're welcome & thanks for the feedback