Running a macro from validation box

Hi Brian

Not too sure what you mean by "button in a validation box" but you can have a macro run on changing from yes to no.

Right click on your sheet name tab and select "View Code", paste in this code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Address = "$A$1" Then
Select Case Target
Case "Yes"
Run "Macro1"
Case "No"
Run "Macro2"
End Select
End If
End Sub

Dave

OzGrid Business Applications

Didn't work. I'm trying to run a macro when I click on the Yes button in a data validation dialogue box, I'm sure it's pretty basic.