PDA

View Full Version : Solved: Call Form After Cell Update



Emoncada
01-20-2008, 09:14 AM
I need code to call a Form after Cell B6 Is updated or changed. how can I make this happen

Carl A
01-20-2008, 09:55 AM
One Way

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

Emoncada
01-20-2008, 11:04 AM
That looks good Carl A Thanks a lot.