Combine two Private Sub Worksheet_Change VBA codes

Hi,

I have been scratching my head all day.

Can anyone please help or point me in the right direction.

I have two Worksheet Change codes and I want to combined into one procedure (see below) How can this been done ?

Please Login or Register  to view this content.

Thank you in Advance

Slosh :-)

To combine two worksheet change events, you would have to use something different than "exit SUb"

Please Login or Register  to view this content.

But in your case I believe this would work for you

Please Login or Register  to view this content.

Originally Posted by porucha vevrku

... or use the procedure "Workbook_SheetChange (ByVal Sh As Object, ByVal Target As Range)" in the module "ThisWorkbook"

Hi Porucha,
Could you elaborate on this ...?

Originally Posted by porucha vevrku

For me, it's an attempt to combine procedures from two different sheets. Here, perhaps the more appropriate procedure would be "Workbook_SheetChange (ByVal Sh As Object, ByVal Target As Range)" in the module "ThisWorkbook" ... I think so.

The OP wanted to have more than one worksheet_change event for the same sheet.