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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.