overlapped functions in vba for excel
 

Hello All

I have written a vba app to get data from a device and display it on a
graph in excel. The data is fetched via the serial port using the Win32
communications api. These functions used are overlapped, hence the
other threads & applications run as normal during a relatively slow
communications.

Essentially the overall algorithm is:

cell =1
while cell < 100
if data available or timeout
place data or error in cell
cell++

This locks excel in the while loop, busy and cannot respond to user
commands. How do I put something in this loop to say ' check the rest
of excel needs'?

Thanks in anticipation.

Billy

overlapped functions in vba for excel
 

Add

DoEvents

in each iteration of the loop.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"blinkots" wrote in message
...
Hello All

I have written a vba app to get data from a device and display it on a
graph in excel. The data is fetched via the serial port using the Win32
communications api. These functions used are overlapped, hence the
other threads & applications run as normal during a relatively slow
communications.

Essentially the overall algorithm is:

cell =1
while cell < 100
if data available or timeout
place data or error in cell
cell++

This locks excel in the while loop, busy and cannot respond to user
commands. How do I put something in this loop to say ' check the rest
of excel needs'?

Thanks in anticipation.

Billy

overlapped functions in vba for excel
 

Bob Phillips wrote:
Add

DoEvents

in each iteration of the loop.

Thanks .. this did help.

Billy