Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can OnEntry be limited to certain cells only??
I can use OnEntry to trigger a macro when any cell on a given sheet is edited -- Sub Auto_Open() Worksheets("Sheet1").OnEntry = "TriggeredMacro" End Sub Is there a way to limit the triggering to just certain cells? so that only editing in those cells initiates the macro? Thanks in advance ... -- Chief Wiggums ------------------------------------------------------------------------ Chief Wiggums's Profile: http://www.excelforum.com/member.php...o&userid=16934 View this thread: http://www.excelforum.com/showthread...hreadid=516531 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can OnEntry be limited to certain cells only??
example from Help:
Worksheets("Sheet1").Activate Set isect = Application.Intersect(Range("rg1"), Range("rg2")) If isect Is Nothing Then MsgBox "Ranges do not intersect" Else isect.Select End If "Chief Wiggums" wrote in message news:Chief.Wiggums.23sqla_1140889801.4844@excelfor um-nospam.com... I can use OnEntry to trigger a macro when any cell on a given sheet is edited -- Sub Auto_Open() Worksheets("Sheet1").OnEntry = "TriggeredMacro" End Sub Is there a way to limit the triggering to just certain cells? so that only editing in those cells initiates the macro? Thanks in advance ... -- Chief Wiggums ------------------------------------------------------------------------ Chief Wiggums's Profile: http://www.excelforum.com/member.php...o&userid=16934 View this thread: http://www.excelforum.com/showthread...hreadid=516531 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
can OnEntry be limited to certain cells only??
Hmmm ... I'm think this involves the Caller property, which can somehow be used to return the address of the cell whose editing triggered the macro. If I had that, then that could serve as Range("rg1") in the example you've given and it would work perfectly. Thanks very much, Jim. -- Chief Wiggums ------------------------------------------------------------------------ Chief Wiggums's Profile: http://www.excelforum.com/member.php...o&userid=16934 View this thread: http://www.excelforum.com/showthread...hreadid=516531 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
can OnEntry be limited to certain cells only??
OK, the following seems to work: Set isect = Application.Intersect(Range(Application.Caller.Add ress), Range("rg2")) If isect Is Nothing Then MsgBox "Ranges do not intersect" Else isect.Select End If In this example, Application.Caller.Address returns the address of the cell which was edited. So one can test and then act, depending on whether that cell was a specified cell or not. THanks again, Jim. -- Chief Wiggums ------------------------------------------------------------------------ Chief Wiggums's Profile: http://www.excelforum.com/member.php...o&userid=16934 View this thread: http://www.excelforum.com/showthread...hreadid=516531 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
can OnEntry be limited to certain cells only??
Thanks for the feedback
"Chief Wiggums" wrote in message news:Chief.Wiggums.23surb_1140895201.7253@excelfor um-nospam.com... OK, the following seems to work: Set isect = Application.Intersect(Range(Application.Caller.Add ress), Range("rg2")) If isect Is Nothing Then MsgBox "Ranges do not intersect" Else isect.Select End If In this example, Application.Caller.Address returns the address of the cell which was edited. So one can test and then act, depending on whether that cell was a specified cell or not. THanks again, Jim. -- Chief Wiggums ------------------------------------------------------------------------ Chief Wiggums's Profile: http://www.excelforum.com/member.php...o&userid=16934 View this thread: http://www.excelforum.com/showthread...hreadid=516531 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move cursor on limited cells. | Excel Worksheet Functions | |||
Limited amount of cells in a formula | Excel Worksheet Functions | |||
REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
populate a limited # of cells with a set value | Excel Worksheet Functions | |||
Application onEntry with IF then statement | Excel Programming |