Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there any event like worhsheet_change for ranges?
Hi,
Just wanted to know wether there is anything like worksheet_change at a range/cell level. What I want to do is trigger some code for a specific set of cells ,some for a specific set of rows, some for a specific set of columns, etc .. Adding it ALL to worksheet_change will make it sloppy ... Thanks Abhinav |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there any event like worhsheet_change for ranges?
Hi
you have to use the worksheet_change event (there's no cell_change_event). Within the worksheet_change event you can test the target range object and check which action to execute -----Original Message----- Hi, Just wanted to know wether there is anything like worksheet_change at a range/cell level. What I want to do is trigger some code for a specific set of cells ,some for a specific set of rows, some for a specific set of columns, etc .. Adding it ALL to worksheet_change will make it sloppy ... Thanks Abhinav . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there any event like worhsheet_change for ranges?
Frank Kabel wrote: Hi you have to use the worksheet_change event (there's no cell_change_event). Just what i was afraid of :( Within the worksheet_change event you can test the target range object and check which action to execute If this is the only way to do it, doesnt it potentially make the worksheet_change event a big module with lots of ifs and cases .. or am i missing something ? Just wanted to be sure that there is no shortcut/workaround to using this .. as this seems a bit complex... Thanks Abhinav -----Original Message----- Hi, Just wanted to know wether there is anything like worksheet_change at a range/cell level. What I want to do is trigger some code for a specific set of cells ,some for a specific set of rows, some for a specific set of columns, etc .. Adding it ALL to worksheet_change will make it sloppy ... Thanks Abhinav . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there any event like worhsheet_change for ranges?
[...]
Just wanted to be sure that there is no shortcut/workaround to using this .. as this seems a bit complex... Hi shouldn't be that complex. Use Intersect and/or select case target.address for this |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referring to Ranges in Change-Event Macro? | Excel Discussion (Misc queries) | |||
Event Procedures: Event on Worksheet to fire Event on another Worksheet | Excel Programming | |||
change event/after update event?? | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
Event validating two ranges with dates | Excel Programming |