Multiple changes in Worksheet_Change(ByVal Target As Range)

Hi,

I am new to VBA and trying to understand if there is a way to have to multiple changes to a worksheet when a value changes.

Please Login or Register  to view this content.

Cell E47 is a drop down box with populated values of blank, yes, no. If one of the values is selected, a macro is run to do the next step. I can get this step to run fine but it is the next bits after the other cells are setup that I am having difficulty in triggering.

If yes is selected in cell E47, the macro is run to create a list and conditional formatting in cell L47. This would then be the next step to running the next sequence and then the user would select the drop down options in here of yes, no, blank, to trigger the next part of the event - unhide rows to fill in data in a cell
If no is selected in cell E47, the macro is run to create a list and conditional formatting in cell N47. This would then be the next step to running the next sequence and then the user would select the drop down options in here of yes, no blank, to trigger the next part of the event - unhide rows to fill in data in a cell
If no is selected in cell L47, the macro is run to create a list and conditional formatting in cell N47. This would then be the next step to running the next sequence and then the user would select the drop down options in here of yes, no blank, to trigger the next part of the event - unhide rows to fill in data in a cell

As I have said I am a new to VBA and have started to get my head around the basics so any help is greatly appreciated to help with my learning and understanding of how the worksheet change event works in detail

Thanks