Hi all,
is there a way I can fire up a macro on change of a certain columns' cells?
I need to regularly change the values in column C, and when I do I want my macro to run...
thank sin advance,
Matt
Hi all,
is there a way I can fire up a macro on change of a certain columns' cells?
I need to regularly change the values in column C, and when I do I want my macro to run...
thank sin advance,
Matt
Take a look at:
http://www.cpearson.com/excel/events.htm
You want a Worksheet_Change event.
"matpj" wrote:
>
> Hi all,
>
> is there a way I can fire up a macro on change of a certain columns'
> cells?
> I need to regularly change the values in column C, and when I do I want
> my macro to run...
>
> thank sin advance,
> Matt
>
>
> --
> matpj
> ------------------------------------------------------------------------
> matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
> View this thread: http://www.excelforum.com/showthread...hreadid=534095
>
>
'-----------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
'-----------------------------------------------------------------
Const WS_RANGE As String = "C:C"
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
'do your stuff
End With
End If
ws_exit:
Application.EnableEvents = True
End Sub
'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"matpj" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> is there a way I can fire up a macro on change of a certain columns'
> cells?
> I need to regularly change the values in column C, and when I do I want
> my macro to run...
>
> thank sin advance,
> Matt
>
>
> --
> matpj
> ------------------------------------------------------------------------
> matpj's Profile:
http://www.excelforum.com/member.php...o&userid=21076
> View this thread: http://www.excelforum.com/showthread...hreadid=534095
>
hi,
i'v just been asked by the end user of this if its possible to run the macro using the Worksheet Activate property or the Worksheet Deactivate?
I tried just pasting the code into these properties in turn but nothing happened.
when I change a value and then go to a different workbook, nothing seems to run at all.
is there something i'm not doing?
the code i'm trying to use is:
thanks in advance,Please Login or Register to view this content.
Matt
back to the top.
Does anyone th answer to this.
I've attempted several things, but none of them seem to work..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks