Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User switching between sheets while data is being logged
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User switching between sheets while data is being logged
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Logged in User Name in formula... | Excel Discussion (Misc queries) | |||
Getting Logged in User Name in formula... | Excel Worksheet Functions | |||
Auto Updating the Logged in User | Excel Discussion (Misc queries) | |||
How do you reference the logged on user name in excel? | Excel Discussion (Misc queries) | |||
Find Out Logged in User | Excel Programming |