G Guest Oct 23, 2004 #1 upon entry of data in any cell in d column how do I get a user form to appear? Thanks BD
F Frank Kabel Oct 23, 2004 #2 Hi use the worksheet_change event. See: http://www.cpearson.com/excel/events.htm
R Ron de Bruin Oct 23, 2004 #3 Hi Brian You can use this event in the sheet module Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Target.Column = 4 Then UserForm1.Show End Sub
Hi Brian You can use this event in the sheet module Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Target.Column = 4 Then UserForm1.Show End Sub
