| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub Worksheet_Change(ByVal Target As Range)
Specifying Target Not Working...
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range("i4_Disc") Then Msgbox €śCell D11 has changed.€ť End If End Sub Thanks, Arturo |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Private Sub Worksheet_Change(ByVal Target As Range)
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$D$11" Then Msgbox €śCell D11 has changed.€ť End If http://www.cpearson.com/excel/events.htm d'oh! "Arturo" wrote: Specifying Target Not Working... Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range("i4_Disc") Then Msgbox €śCell D11 has changed.€ť End If End Sub Thanks, Arturo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple values in Private Sub Worksheet_Change(ByVal Target As R | Excel Discussion (Misc queries) | |||
| Control Toolbox and Private Sub Worksheet_Change(ByVal Target As R | Excel Discussion (Misc queries) | |||
| Control Toolbox and Private Sub Worksheet_Change(ByVal Target As R | Excel Discussion (Misc queries) | |||
| Control Toolbox and Private Sub Worksheet_Change(ByVal Target | Excel Discussion (Misc queries) | |||
| Private Sub Worksheet_Change(ByVal Target As Excel.Range) | Excel Worksheet Functions | |||
Linear Mode
