Solved: Call Form After Cell Update

[Emoncada]

I need code to call a Form after Cell B6 Is updated or changed. how can I make this happen

[Carl A]

One Way

[vba]Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
Set rng = Range("B6")
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, rng) Is Nothing Then
UserForm1.Show
End If
End Sub[/vba]

[Emoncada]

That looks good Carl A Thanks a lot.