Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change Event triggered off specific cell
I know how to use Worksheet Change events. But I do not know how t
trigger them off a specific cell. The following works off a change i any cell. Sub Worksheet_Change(ByVal Target As Excel.Range) Call ProcedureA End Sub How do I edit this so that is triggers off a specific cell? Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change Event triggered off specific cell
See my answer to your question below. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "ExcelMonkey " wrote in message ... I know how to use Worksheet Change events. But I do not know how to trigger them off a specific cell. The following works off a change in any cell. Sub Worksheet_Change(ByVal Target As Excel.Range) Call ProcedureA End Sub How do I edit this so that is triggers off a specific cell? Thanks --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change Event triggered off specific cell
ExcelMonkey
You can not have it trigger off a particular cell. You need to test the target.address if target.address ="$A$1" then do something end if also look at using Intersect to test your targe -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing Cell Contents / Worksheet_Change Event | Excel Worksheet Functions | |||
Macro triggered by an event | Excel Discussion (Misc queries) | |||
BeforeSave sub won't save another workbook when triggered by another event sub | Excel Programming | |||
Is this an Excel workbook event triggered AFTER saving | Excel Programming | |||
Event triggered by Hiding/Unhiding columns? | Excel Programming |