How to make this macro work on different sheets

[barman]

Hi,

I use the following macro in a userform to delete a selected row on sheet2. We are adding about 20 sheets to our workbook and I want to use the same macro on each of the new sheets. I know I can create a new userform with the macro for each of the 20 sheets and replace the "Sheet2" with the different sheet names.

Instead of having to create 20 duplicate userforms/macros with the only difference being the Sheet name, is there a way to write this macro without the sheet name, so it works on any sheet that calls the userform?

Each sheet will work independently from each other, different rows being deleted at different times on the different sheets... so putting all the sheet names in the array won't work.

Please Login or Register  to view this content.

[Logit]

.
Try :

Please Login or Register  to view this content.

[jolivanes]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Incorporate code into your current code where you want to delete row in all sheets.

Please Login or Register  to view this content.

[barman]

Hey Logit,

Thank you for the help... I tried your code change and when clicking the command button to run the macro and delete the row, it doesn't do anything. It will throw the error handler, so that still works. Any other ideas?

[Fluff13]

How about

Please Login or Register  to view this content.

[jolivanes]

Did I misunderstand what you want to do?
I understood that you would have selected a cell, got the userform, did some stuff and now had to delete the same row where you selected in all sheets.
Or do you want to delete a selected row in whatever sheet is open when you get the userform and not the others?

Or if you open the UserForm as vbModeless you can select any cell/row while the UserForm is open and delete that cell/row

Please Login or Register  to view this content.

[barman]

Thank you Fluff13 works great!

[Fluff13]

You're welcome & thanks for the feedback