Serial COM Ports in Excel VBA

LeoKing 

Hello and thanks for your interest in SerialComms VBA.

You may have a timing problem between VBA and your instrument. 

Modern PC is simply far too fast for relatively slow serial ports and attached devices.

Try adding a delay between starting the COM port and sending the Start Sampling command. 

Add a second delay between sending the command and waiting for a response.

There's an example function at the end of the listing below which shows how to do that. 

https://github.com/Serialcomms/Serial-Ports-in-VBA-new-for-2022/blob/main/SERIAL_PORT_VBA.bas

Regards,

SerialComms