| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
