Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #107983

Re: identifying a cell with worksheet_change

From Claus Busch <claus_busch@t-online.de>
Newsgroups microsoft.public.excel.programming
Subject Re: identifying a cell with worksheet_change
Date 2015-08-20 19:05 +0200
Organization A noiseless patient Spider
Message-ID <mr51ak$6vr$1@dont-email.me> (permalink)
References <de6fea7a-37d9-498a-be5b-4e64be655835@googlegroups.com>

Show all headers | View raw

Hi Art,

Am Thu, 20 Aug 2015 09:36:12 -0700 (PDT) schrieb c1802362@cox.net:

>     Private Sub Worksheet_Change(ByVal Target As Range)
> 
>         MsgBox ActiveCell.Address
> 
>     End Sub

try:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Address
End Sub


Regards
Claus B.
-- 
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

identifying a cell with worksheet_change c1802362@cox.net - 2015-08-20 09:36 -0700
  Re: identifying a cell with worksheet_change Claus Busch <claus_busch@t-online.de> - 2015-08-20 19:05 +0200
    Re: identifying a cell with worksheet_change c1802362@cox.net - 2015-08-20 11:33 -0700

csiph-web