Thread: user forms
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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


Reply With QuoteReply With Quote