Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Event
Hello. How can I have a worksheet_Change event trigger only when certain
cells (more specifically - when a cell with a certain range of cells) are changed? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Event
I don't think it is possible: the range object doesn't have any event that
can be triggered. You have to understand what range generated the event inside the worksheet_change event. Paolo "Steph" ha scritto nel messaggio ... Hello. How can I have a worksheet_Change event trigger only when certain cells (more specifically - when a cell with a certain range of cells) are changed? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Event
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C1:C5")) Is Nothing Then MsgBox "Changed!" End If End Sub Take care because Target may not always be just the single cell. -- Rob van Gelder - http://www.vangelder.co.nz/excel "Steph" wrote in message ... Hello. How can I have a worksheet_Change event trigger only when certain cells (more specifically - when a cell with a certain range of cells) are changed? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Event
What are the cells?
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then MsgBox ("ACTIVE") Else End If End Sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Event
Ooh..his is better.
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Event
Thanks so much Rob! Can I ask a follow up to your post on the other message
I posted regarding the "before event"? You posted "You must store the value separately as the cell changes so you can refer to the value at next change." How would I go about doing that? My goal in this is to create a change log on a worksheet that multiple people will be changing. Thanks again for your help!! "Rob van Gelder" wrote in message ... Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C1:C5")) Is Nothing Then MsgBox "Changed!" End If End Sub Take care because Target may not always be just the single cell. -- Rob van Gelder - http://www.vangelder.co.nz/excel "Steph" wrote in message ... Hello. How can I have a worksheet_Change event trigger only when certain cells (more specifically - when a cell with a certain range of cells) are changed? Thanks! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Event
You're welcome.
You should really stick to the original thread. I've never done change tracking this way before. I'm concerned I couldn't capture every change - I could be wrong.. If I were to give it a serious go, I might create a two column table. First row for cell address, Second row for previous value. Kind of like a transaction log. I'd recommend using Excel's built in Track Changes feature. -- Rob van Gelder - http://www.vangelder.co.nz/excel "Steph" wrote in message ... Thanks so much Rob! Can I ask a follow up to your post on the other message I posted regarding the "before event"? You posted "You must store the value separately as the cell changes so you can refer to the value at next change." How would I go about doing that? My goal in this is to create a change log on a worksheet that multiple people will be changing. Thanks again for your help!! "Rob van Gelder" wrote in message ... Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C1:C5")) Is Nothing Then MsgBox "Changed!" End If End Sub Take care because Target may not always be just the single cell. -- Rob van Gelder - http://www.vangelder.co.nz/excel "Steph" wrote in message ... Hello. How can I have a worksheet_Change event trigger only when certain cells (more specifically - when a cell with a certain range of cells) are changed? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Change event | Excel Discussion (Misc queries) | |||
Worksheet Change Event | Excel Discussion (Misc queries) | |||
Worksheet Change event | Excel Programming | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Worksheet change event | Excel Programming |