Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'On change' property
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
'On change' property
'-----------------------------------------------------------------
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
'On change' property
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
'On change' property
hi, i'v just been asked by the end user of this if its possible to run th macro using the Worksheet Activate property or the Workshee Deactivate? I tried just pasting the code into these properties in turn but nothin happened. when I change a value and then go to a different workbook, nothin seems to run at all. is there something i'm not doing? the code i'm trying to use is: Code ------------------- Private Sub Worksheet_Deactivate() Const WS_RANGE As String = "D:D" On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target Call shade End With End If ws_exit: Application.EnableEvents = True End sub ------------------- thanks in advance, Mat -- matp ----------------------------------------------------------------------- matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107 View this thread: http://www.excelforum.com/showthread.php?threadid=53409 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
'On change' property
back to the top. Does anyone th answer to this. I've attempted several things, but none of them seem to work.. -- matpj ------------------------------------------------------------------------ matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076 View this thread: http://www.excelforum.com/showthread...hreadid=534095 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change insidewidth property | Charts and Charting in Excel | |||
Change property of comments only | Excel Programming | |||
Combobox change property | Excel Programming | |||
change Company property | Excel Programming | |||
Worksheet / Workbook Change Property | Excel Programming |