trigger problem
Hi, I want to trigger a script whenever the data changes in a cell. For testing purposes I used this little script: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("c1")) Is Nothing Then Range("a1") = 123 End If End Sub The problem: If I type something in c1 everything goes ok But when I put this =[Book3]Sheet1!$A$1 in c1 and work tru a link and change cell a1 in book 3 nothing happens. How can I trigger the script thru a link that changes? Thanks -- climax ------------------------------------------------------------------------ climax's Profile: http://www.excelforum.com/member.php...o&userid=30816 View this thread: http://www.excelforum.com/showthread...hreadid=507503 |
trigger problem
You'll want to use a different event. _change is when you type something in.
Maybe you can use worksheet_calculate? climax wrote: Hi, I want to trigger a script whenever the data changes in a cell. For testing purposes I used this little script: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("c1")) Is Nothing Then Range("a1") = 123 End If End Sub The problem: If I type something in c1 everything goes ok But when I put this =[Book3]Sheet1!$A$1 in c1 and work tru a link and change cell a1 in book 3 nothing happens. How can I trigger the script thru a link that changes? Thanks -- climax ------------------------------------------------------------------------ climax's Profile: http://www.excelforum.com/member.php...o&userid=30816 View this thread: http://www.excelforum.com/showthread...hreadid=507503 -- Dave Peterson |
All times are GMT +1. The time now is 01:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com