Attach Macro to List on Worksheet

[ZaneCOYS]

Hi,

I have a spread sheet that records when work comes in, this has a drop list in column H. This defaults to Work O/S and the user will choose 'Work Completed' when the have completed the work. I want to add a Macro to the list so that when the user chsnges the list to 'Work Completed' the Macro runs.

Hope that makes sense.

Cheers all

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 8 And Target.Value = "Work Completed" Then Call MyMacro
End Sub

Change MyMacro to the name of your macro.

 

[ZaneCOYS]

It seems so simple when somebody else writes it. Thanks chap