VBA serial COM port logging

Hello,

I'm new to VBA but struggling to find anything that can help me with my problem.

I'm working on a project where i need to log a sensor via serial connection to my computer. Right now it only sends data via Hyper-terminal after i give it a command.
I would like to make an Excel VBA program that can send the commands and receives the data. This way i can log the data form my sensor continually instead of just by command.

The sensor is connected via an USB to the computer with a driver to make it a virtual COM port.

If anybody knows how to make a program like this, has an example or knows any good tutorials on this particular subject i would love to hear them!

Thanks