| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
user forms
upon entry of data in any cell in d column how do I get a user form to appear?
Thanks BD |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New to User Forms | New Users to Excel | |||
| User Forms - Max Me | Excel Programming | |||
| User forms | Excel Programming | |||
| User Forms | Excel Programming | |||
| User forms | Excel Programming | |||
Linear Mode
