Private Sub Worksheet_Change(ByVal Target As Range)

Posted to microsoft.public.excel.programming

Arturo

external usenet poster

Posts: 108

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple values in Private Sub Worksheet_Change(ByVal Target As R	davemon	Excel Discussion (Misc queries)	2	September 21st 07 07:40 PM
Control Toolbox and Private Sub Worksheet_Change(ByVal Target As R	[email protected]	Excel Discussion (Misc queries)	1	August 17th 07 09:38 AM
Control Toolbox and Private Sub Worksheet_Change(ByVal Target As R	Toppers	Excel Discussion (Misc queries)	0	August 17th 07 02:02 AM
Control Toolbox and Private Sub Worksheet_Change(ByVal Target	Toppers	Excel Discussion (Misc queries)	0	August 17th 07 01:52 AM
Private Sub Worksheet_Change(ByVal Target As Excel.Range)	[email protected]	Excel Worksheet Functions	0	December 21st 06 02:13 AM

All times are GMT +1. The time now is 08:44 AM.

Menu

About Us