I know there are loads of posts re. this as I've read most of them, but the code I have just doesn't work. Would someone be kind enough to have a look at it and tell me why please.
All I want to do is run my Goalseek macro once the contents from a data validation list is changed. It works when the non-drop down list boxes are changed.
The code is in the sheet code and has worksheet and change selected from drop-down menus at the top, and goalseek macro is in module 1, as the calculations are done on a separate sheet to the values changing. Thanks for any help.
Alan
All I want to do is run my Goalseek macro once the contents from a data validation list is changed. It works when the non-drop down list boxes are changed.
The code is in the sheet code and has worksheet and change selected from drop-down menus at the top, and goalseek macro is in module 1, as the calculations are done on a separate sheet to the values changing. Thanks for any help.
Alan
Code:
Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Intersect(Target, Range("b1:b13")) Is Nothing Or Target.Cells.Count > 1 Then
Module1.Goalseek
End If
Application.EnableEvents = True
End Sub