user forms
 

upon entry of data in any cell in d column how do I get a user form to appear?
Thanks
BD

user forms
 

Hi
use the worksheet_change event. See:
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Brian" schrieb im Newsbeitrag
...
upon entry of data in any cell in d column how do I get a user form
to appear?
Thanks
BD

user forms
 

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Brian" wrote in message ...
upon entry of data in any cell in d column how do I get a user form to appear?
Thanks
BD