User switching between sheets while data is being logged

[steve28]

Hello and thanks very much for any help you might give me,

I wrote a VBA which collects and logs data coming in through a serial port. The data is being logged into several different excel sheets. But while it is logging, the user cannot actively switch between the sheets to view its progress. Does anyone know of a way to do this???

Thanks,
Steve

[Bernie Deitrick]

Steve,

I think you would need to use the Ontime event to schedule the data-logging macro to be run again:
If once a second is good....

Sub DoData()
NextTime = Now + TimeValue("00:00:01")
'Do your data logging here, just once
Application.OnTime NextTime, "DoData"
End Sub

Sub StopLogging()
Application.OnTime NextTime, "DoData", schedule:=False
End Sub

HTH,
Bernie
MS Excel MVP


"steve28" <[email protected]> wrote in message
news:[email protected]...
>
> Hello and thanks very much for any help you might give me,
>
> I wrote a VBA which collects and logs data coming in through a serial
> port. The data is being logged into several different excel sheets.
> But while it is logging, the user cannot actively switch between the
> sheets to view its progress. Does anyone know of a way to do this???
>
> Thanks,
> Steve
>
>
> --
> steve28
> ------------------------------------------------------------------------
> steve28's Profile: http://www.excelforum.com/member.php...o&userid=37195
> View this thread: http://www.excelforum.com/showthread...hreadid=569070
>