Helllllllllpppp Problem with macros and lists.

[Diane_E_Thomas]

Please can someone help me.

I have created a list of 14 things using data validation/ lists, but now I want to asign a macro to each of the 14 options, so that when I select an option from my drop down list a macro will automatically run, and if I chose another option, another macro would run. Perhaps I need a different way of creating my list? Any advice would be greatly appreciated.

 

[Mudface]

Ah, what's happening is that you're changing a cell, calling macro2, which then changes a cell and calls itself recursively. Try changing the event subroutine to this:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Target.Address <> "$O$9" Then Exit Sub
If Target.Value = "Triangular" Then
Run ("macro2")
End If

End Sub

This will only run when the cell being changed is O9 and it's changed to 'Triangular'. HTH.

 

[Diane_E_Thomas]

Do I need to define the target.address? I still can't get it to do anything!

 

[Mudface]

Sorry, Diane, this works OK for me on a test sheet. Again, this will only run if the cell being changed is O9 and the value it is changed to is 'Triangular' (case-sensitive). It won't run if 'Triangular' is already in the cell, you would need to put in another value, then put 'Triangular' back in.