Search results for query: *

I tried using the Worksheet.Change, but it would only update the data once and never run again. Here is what I used for the code in the worksheet (scanupdate): Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Me.Range("A1")) Is Nothing Then...

So I tried running breaks, but never really found anythiing (no error messages). Any other suggestions out there? Thanks!

Soo.....no good codes out there? I need a simple code that will check a worksheet in the workbook for any data value change and then run macro after data change/update (from external link OPC server). Thanks!

Not sure I know how do manage that....? Im not at much of an expert when it comes VBA code. Any tips would great.

Maybe, I should ask what I need to happen, and perhaps that will be easier to understand my problem. At this section of the code: Application.StatusBar = "Start Data Collection" Worksheets("scanupdate").OnData = "fivesecondscandelay" the macro is suppose to look at worksheet scanupdate...

Its sort of complex, but here it is anyway. If I just run this Sub by steping through it, it runs just fine, its getting here from the previous code that is my problem. [3eyes] Sub getscandata() Application.ScreenUpdating = False Application.DisplayAlerts = False current_sheet =...

.OnData was used when it ran under Excel 2000 (looking for changes at cell A1) at the worksheet "scanupdate".

Anyone??

Ok, ran into some issues, partially works. It appears to run once, then do nothing. I have cell A1 linked to an OPC server which, which updates about every 15 seconds, which is worksheet scanupdate, but after I inserted the above code into the Excel Object Sheet3 (scanupdate), it will only...

Thanks! I will give it a try and let you know.

Hi, I am looking to see how to use the following Change function under Excel 2010 to run a macro within the worksheet. I was previously using the Worksheets("scanupdate").OnData = "fivesecondscandelay" code to run my macro FiveSecondScanDelay (under Excel 2000/3), but for some reason not working...

bump

Thanks for the reply. The GetScanData is called by fivesecondscandelay, Sub fivesecondscandelay() Application.OnTime Now + TimeValue("00:00:05"), "getscandata" End Sub I think I am close to my problem, what happend during the Excel upgrade, we also lost the DDE links and updated to OPC...

Hi, I have a worksheet that was created in Excel 2000 which has several macros and works well in this environment. However, they have upgraded to Excel 2007 and the worksheet no longer runs correctly without any intervention. If I manually step-thru the macros, the worksheet runs OK. But I have...